Validating form data

[dweekley]

I am attempting to validate the data entered into the form. Blanks, format, etc.

I am thinking that this needs to be done at BeforeUpdate and UnLoad? If this is true then the VBA should be a function and called up so the VBA is same where ever it is used.

TIA

[RuralGuy]

You will not need both BeforeUpdate and UnLoad events. The BeforeUpdate will catch all changes.

[dweekley]

Sweet. One less thing to think about.

BeforeUpdate happens before the UnLoad. Is there a cheat sheet for the order of events? I found something on Update and insert, but didn't include Unload, Exit.

[RuralGuy]

Here's a link that will be helpful: https://support.office.com/en-us/article/Order-of-events-for-database-objects-E76FBBFE-6180-4A52-8787-CE86553682F9

[RuralGuy]

If you really are using Access XP (which I have) then while you not looking at code, pressing F1 and searching for Events should give you the same thing.

[dweekley]

Thank you much. Nice. More reading. That should help get my head wrapped around a few things.