Prevent OnEnter of subform from adding the record on the main form

[tekila]

Both my subform and main form are linked to the same table. On the main form, there is a Add button that saves a record but if the user fills in all the entries in the main form but did not hit Add button,instead sets focus to the subform, the record is saved. How can I prevent the saving of the record in OnEnter of subform?

 

[LittleSmudge]

If you still want to retain the data you can't .. ..

unless you UNBIND all of the controls on the main form and populate then / update then using Recordsets.


G LS

 

[tekila]

I don't quite get what you mean but what I did was to use a list box instead of a subform. In this way, whatever I do to the list box has no effect on the main form. Can't think of a better solution...