You typically use the following events to determine when Microsoft Access runs a validation macro or event procedure from a form.
Form event | Use for validation |
---|---|
BeforeUpdate | Before saving new or changed data in a record |
OnDelete | Before deleting a record |
Control event | Use for validation |
---|---|
BeforeUpdate | Before saving new or changed data in a control |
OnExit | Before leaving a control |