Add Rec in FormA from FormB 1

[6kleg]

My FormA is a continuous form for records in a Table1. Not all fields are shown. FormB is a Single Form view of the same table, with all fields displayed.

I want the user to be able to click a button in FormA to add a record, but I don't want the record added in the COntinuous form. I want to open FormB and set off FormB's AddRecord command button's click event which will force the user to enter all required fields.

The FormB button code in a Private Sub procedure is simply

DoCmd.GoToRecord , , acNewRec

A button click in FormA opens FormB. How can I call the FormB AddRecord button's click event while still in the FormA procedure?

Thanks for any help.

 

[PHV]

Take a look at the 5th argument of the DoCmd.OpenForm method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[6kleg]

PHV,

That's just what I needed. Thanks. And have a star.