VBA event definitions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
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.
 
Back
Top