40 separate forms or 1 form with hidden tabs?

[Guest]

I have a database which will have about forty forms.

There are nine tab pages that common to every form and are based on the same
linked tables.

The controls in each tab page are in a subform, so that if I need to make a
change, I can make it to one subform rather than forty forms.

Each form will also have one or two unique tab pages/subforms are based on
separate tables.

Is this the best way to do this? Or should I not use subforms and instead
put all the tab pages on one form and hide the tab pages that aren’t needed
when the user selects the form they want?

Thank you

Peter

 

[John Vinson]

I have a database which will have about forty forms.

There are nine tab pages that common to every form and are based on the same
linked tables.

The controls in each tab page are in a subform, so that if I need to make a
change, I can make it to one subform rather than forty forms.

Each form will also have one or two unique tab pages/subforms are based on
separate tables.

Is this the best way to do this? Or should I not use subforms and instead
put all the tab pages on one form and hide the tab pages that aren’t needed
when the user selects the form they want?

A Form with 40 "live" (even if hidden) subforms will probably be
ungainly and VERRRY slow to open (all subforms must be opened and
populated first before the form is displayed).

I'd suggest keeping the form "light" if possible and using techniques
such as dynamically changing the Recordsource and/or SourceObject
properties of the subforms.

John W. Vinson[MVP]

 

[Guest]

That's the path I had taken. Thanks for giving me peace of mind.

Peter