I have a form with 2 subforms. Every time the OnCurrent event fires in subform 1 i want to change data in subform2.
After the form is loaded, this works fine - but during load, it appears that the 2nd subform is not available. I get the 'can't reference form/control error...

It seems that the OnCurrent event of the 1st subform fires before the 2nd subform has even loaded, thus it's controls cannot be referenced.


Is this true? If so, is there any way to determine the order that subforms load? Alphabetically? In order of creation?

Any input on this would be appreciated.

Thank you,
Evan