Access & VBA event model explained

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Atlas - 28 Jan 2005 12:22 GMT

Is there any free Internet resource available that explains in depth how the
Access 2002 (VBA) Event model works?
Particularly the events hiearchy and how events are fired when a form is
loaded...dunno why but I'm experiencing strange (to me) beheaviour tracking
events in the debugger, like the subform's Current event being fired up
before the main form Open event....

Thanks

Reply to this Message

Brian - 28 Jan 2005 13:26 GMT

> Is there any free Internet resource available that explains in depth how the
> Access 2002 (VBA) Event model works?

Don't know. Never seen one. If you can get hold of a copy of Access 97,
it's help system contains a very good explanation of the sequence of events
for a range of circumstances. I haven't seen any such thing in the dismal
post-97 help system, and I imagine that, like a great deal of other good
stuff, it is simply not there.

> Particularly the events hiearchy and how events are fired when a form is
> loaded...dunno why but I'm experiencing strange (to me) beheaviour tracking
> events in the debugger, like the subform's Current event being fired up
> before the main form Open event....

It's a well-known "feature" of Access that subforms load before the main
form.

Reply to this Message

Roger Carlson - 28 Jan 2005 16:36 GMT

Yes, it is still there in the Access 2000+ help system, but it is very
cleverly hidden. Here's how you find it:

1) Open any code module, THEN open the Help system. (Visual Basic Help is
very different from Access Help)
2) Type "Event" into the Keywords section of the Index tab
3) On the right you will see the "Events and Event Properties Reference"
page. Click "See Also"
4) On the Topics Found dialog box, choose "Find out when events occur"

That's it.

(Isn't it bizzare that I have to give instructions on how to use the Hellp
system?)

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> > Is there any free Internet resource available that explains in depth how
> the
[quoted text clipped - 14 lines]
> It's a well-known "feature" of Access that subforms load before the main
> form.

Reply to this Message