Subform and dialog mode

[tranchemontaigne]

I have a data entry form that is opened in dialog mode. There is a subform on the data entry form. When I first open the form I can add data through the subform. If I close out of the data entry form and reopen it, The subform becomes "locked" and I cannot move the cursor to any of the text boses on the subform. There are no "enable" events in any of the VBA code used to open or close the data entry form.

Any thoughts on why it initially works and then stops? I would like to have the subform always available for data entry.

 

[tranchemontaigne]

Alternately, if someone can tell me how to use VBA code to have the form and subform (these forms are deliberately not linked) automatically move to add a new record without having the forms and subform open without using the "DataEntry = True" approach, I might be able to code around my initial problem.

 

[PHV]

Use acFormAdd as 5th parameter 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 FAQ181-2886