VBA event definitions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FR - 14 Sep 2007 13:36 GMT

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

Reply to this Message

Allen Browne - 14 Sep 2007 13:53 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message

FR - 14 Sep 2007 16:08 GMT

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.

On a personal note: I live in Virginia, USA but I used to visit Perth (and
Mt. Newman and Port headland) in the late 70's, early 80's. I love your city

> This article gives you a sample database for investigating the order of
> events:
[quoted text clipped - 11 lines]
> > Could someone please point me to an article defining all the (access)
> > form-related events and the sequence in which they occur. Thank you

Reply to this Message

Allen Browne - 14 Sep 2007 16:36 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for the reference. Unfortunately it doesn't have links to any
> downloadable file, merely talks about them. Perhaps it is because it
[quoted text clipped - 26 lines]
>> > Could someone please point me to an article defining all the (access)
>> > form-related events and the sequence in which they occur. Thank you

Reply to this Message