Event Priority

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

What is the event priority between the following:

On Current
On Load
On Open
On Activate
 
On Thu, 7 Jan 2010 20:17:38 -0800, "Jay Oken"

Put a line of code in each event:
Debug.Print "Hello from On Current"
etc.
in each of these event, and you will find out in the Immediate Window
(hit Ctrl+G to open).

-Tom.
Microsoft Access MVP
 
On Thu, 7 Jan 2010 20:56:53 -0800, "Jay Oken"

The reason I had you try it is that there are some situations where
some of these events don't fire. For example I believe that the
Current event does not fire for an unbound form.

-Tom.
 
Some years ago I got so irritated by not know what events were firing where,
I did this for every event in the form, it's controls, and subforms. It
helped a ton... I tried to document it, but because certain events only fire
under certain circumstances I gave up on it.

It certainly did help though, at least gave me the fundementals.

What fun <g>

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Jack Leach said:
Some years ago I got so irritated by not know what events were firing
where,
I did this for every event in the form, it's controls, and subforms. It
helped a ton... I tried to document it, but because certain events only
fire
under certain circumstances I gave up on it.

It certainly did help though, at least gave me the fundementals.

What fun <g>
Click to expand...


There is a pretty good help topic on the order of events.
 
Back
Top