Access & VBA event model explained

[Atlas]

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

 

[Brian]

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.

 

[Roger Carlson]

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?)

--
--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