Changing subform load order
Not exactly - but I think you could leave the sourceobject of each subform
blank and then assign the sourceobjects via code in the order you desire.
In the open event of the main form something like:
me.sfrmForm1.sourceobject="sfrmForm1"
me.sfrmForm2.sourceobject="sfrmForm2"
me.sfrmForm3.sourceobject="sfrmForm3"
Would this work for you??
--
Sandra Daigle
[Microsoft Access MVP]
Please do not respond by email, but to the newsgroup so that others can
benefit.
Quote:
> Usually the order in which subforms load is the same as the order in
> which they are added to the parent form. You can alter this by cutting
> and pasting the subform controls, but that technique lacks elegance, to
> say the least. Does anyone have a handle on the parent form's
> (appearently) hidden property or collection that determines the load
> order? It would be nice to be able to tweak it directly.