Choosing the correct Event Procedure
Hello everyone. I would like to know when placing an edit on a field of a form, where is the best place to do it? Now, if there is a problem, I want to be able to cancel the update. So, do I use the [Before Update] of the field or the [Before Update] of the form? Also, how do I cancel the update and set focus on the field when there is a problem?
For instance, I want to have a first name and last name field. So, I would like to check for the presence and set focus if there is a problem in the [before update] procedure of the form, but Access won't let me set focus there. Can anyone please help?