VBA event definitions

[Guest]

Could someone please point me to an article defining all the (access)
form-related events and the sequence in which they occur. Thank you

 

[Allen Browne]

This article gives you a sample database for investigating the order of
events:
Understanding Event Order in Microsoft Access 2000
at:
http://support.microsoft.com/kb/208781/en-us

However, there are cases where the standard sequence is not followed, or
where events (such as Current) fire more than once.

If you are just starting out, I suggest you investigate Form_BeforeUpdate
first. This is the most useful event: use it for validating the record
before it gets written.

 

[Guest]

Thanks for the reference. Unfortunately it doesn't have links to any
downloadable file, merely talks about them. Perhaps it is because it
pertains to Access 2000, I have Access XP (2002) and the files may have been
included with the 2000 version. I have been playing with Access and VBA for
some time and I remember reading an article some time ago describing the
sequence of the various events on starting, changing and ending forms but I
can't find it.

 

[Allen Browne]

Hmm. The article should work; Access 2002 can open the A2000 sample
database, and the order of events will be the same.

Basically the order when you open a form is:
Open, Load, Resize, Activate, Current
though it can change around.

When you unload the form, it's Unload, Deactiveate, Close.