OnEnter is triggered before load?

[markmarko]

Access 2007:
So I have a subform with a control that has an OnEnter event. I'm finding
that the event is triggered when the form is open, even before the OnLoad
event of the form is triggered.

Is this right? Sounds a little silly, so I tested with other controls in
subforms, and they too trigger before the forms OnLoad event. It's basically
rendering the OnEnter event useless, since it's triggering that code at the
wrong time.

Any thoughts?

 

[Linq Adams via AccessMonster.com]

If by

"even before the OnLoad event of the form is triggered"

you mean the OnLoad event of the MAIN form, the answer is yes. Subforms load
and their OnCurrent events fire and the OnEnter event of their first field to
receive focus fire BEFORE the main form's OnLoad event fires.

 

[markmarko]

Hmmm. Well that's surprising to me, so thank you for the explanation.

btw - is there a resource that describes the order of events?

 

[Linq Adams via AccessMonster.com]

From the horse's mouth:

http://office.microsoft.com/en-us/access/HP051867611033.aspx