Event Priority

[Jay Oken]

What is the event priority between the following:

On Current
On Load
On Open
On Activate

 

[Tom van Stiphout]

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

 

[Jay Oken]

Thanks. For anyone interested:

Open
Load
Activate
Current

 

[Tom van Stiphout]

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.

 

[Jack Leach]

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)

 

[Dirk Goldgar]

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>

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