tab control question

[smk23]

I have a form with a tab control with about 15 tabs. Each tab is populated by
a subform (the entire tab is the subform). The intent was to make the form
modular and flexible. I have about 50 subforms in use, and depending on which
layout the user selects, 15 are loaded on the tabs.

Problem is, this is too slow. If I loaded all subforms in the background
(not on the main form) set to visible=false, then loaded the already open
subform on my tabbed form and set it to visible, would this help speed things
up? Any other ideas?

THanks so much.

 

[Rick Brandt]

I have a form with a tab control with about 15 tabs. Each tab is
populated by a subform (the entire tab is the subform). The intent
was to make the form modular and flexible. I have about 50 subforms
in use, and depending on which layout the user selects, 15 are loaded
on the tabs.

Problem is, this is too slow. If I loaded all subforms in the
background (not on the main form) set to visible=false, then loaded
the already open subform on my tabbed form and set it to visible,
would this help speed things up? Any other ideas?

THanks so much.

Leave the SourceObject of each subform control blank and don't populate it until
the user actually visits that TabPage.

Actually in some cases you could just have a single subform control that resides
in front of the TabControl and just change the SourceObject as the TabPage
changes. Then you only ever have one subform loaded at a time.