loading of subforms & performance

[Guest]

My main form has 5 subforms (by default invisible) which I keep invisible
when the form is opened and based on command buttons I make different forms
visible (one at a time).
When the Main form is opened I feel it loads all the subform and slows down
the loading of main form, how can I disable the loading of subforms when the
main form opens?

Thanks,

Ashu

 

[Rick Brandt]

My main form has 5 subforms (by default invisible) which I keep invisible
when the form is opened and based on command buttons I make different forms
visible (one at a time).
When the Main form is opened I feel it loads all the subform and slows down
the loading of main form, how can I disable the loading of subforms when the
main form opens?

If they are the same size just use one subform control and change its
SourceObject property. If different sizes you can still have multiple
subform controls, but just leave the SouceObject property blank until you
make them visible.