subform oncurrent event

[John B. Smotherman]

I was in the middle of posting a different question, when I figured out the
answer to it. However, the answer raised another question. Some background:

running .mdb in Access2007 on XP
Main form has embedded subform
Main form has checkbox that controls AllowAdditions, AllowDeletions and
AllowEdits properties for the subform.

When I advance to a record in the main form, the OnCurrent event checks the
condition of the checkbox and sets a flag for the subform's OnCurrent event
to set the three properties to true or false as applicable. However, the
OnCurrent event for the subform is firing before the OnCurrent event for the
main form. Is this normal? Is there a way I can change it? I could always set
the properties of the subform from the main form, and may change it to that,
but wondered about why the subform's event was firing first.

Thanks

 

[Klatuu]

Yes, it is normal for the subform current event to fire before the main
form. In fact, when you load a form with a subform, the subform loads
first. Even the Access Development team could not tell me why.