I have a header form and a subform.
How can I force the user to add a record to the main from before moving to the subform?
The main form record just satays a a NEW record and therefore no events will fire to verify the data on the main form. So I can't use the before update event - it is just ignored as the main record is new. Even if I add a default value all the iser has to do if select Esc and the beofre update no longer fires beause the main record is set back to a new record.