Working with form events (Access 2000)
Posted on 2006-04-20
I have a form/subform.
After the user enters some data on the main form I want the program to make sure all of the required fields have been completed before they move to the subform or off of the main form altogether. I don't want to use the table-level required field property because I want to customize the message.
My question is- where is the best place to put the code that checks to see if the fields have entries? I get confused by all of the form event choices (UNLOAD, CLOSE, DEACTIVATE, LOST FOCUS, etc..). Would one of them be the best place or is there some other way I should do this? I don't want them to be able to leave the form until they fill in certain fields.