Update table

[Uni03]

Hi - I have a data entry form with a form/subform. The main form has a drop-down to select a device number, then the subform has the details to add for that device to the table. When the form opens, the cursor defaults to the first field in the subform. If the user upon opening wanted to go and select a different device or just closed the form without entering any data. a new record is created. Any way around this - to maybe update the table after all the data is entered in the subform?
Thanks.

 

[PRMiller]

I'd say make sure both forms are unbound, then have a Save button that triggers the Add Record event.

 

[Uni03]

Hi - Sorry for not responding sooner - got side-tracked doing something else. I try your suggestion. The save button will ensure that the user checks and saves theis work. Thanks, again!

 

[PRMiller]

No problem, glad to help!