DB Navigation Design

[Justin]

First off, I'm using a front-end/back-end system.

For navigation of the database, I plan on creating 1 form that has a tab
control on the left for a navigation menu (like a window frame in HTML) and a
tab control on the right which will act as the main form with subforms for
each selection off the navigation menu. This single form will contain a lot
of VB script that will change the navigation menu 'tab' and the subform 'tab'
when the user selects a navigation button.

In other words, every single form in the database will be linked to this
main form as a sub-form within a tab, rather than having the vb code open and
close forms as needed. I felt this would give a better flow of a navigation
menu (and make it easier on me in formatting it) and give one location to
enter all my VB script (in the main form).

My question is, does establishing a form with potentially 50+ tabs and 30
subforms a cause for concern? Will the front-end lag horribly with this much
code and subforms on a single form? I've done it on a smaller scale with
success, but I wanted to check people's opinion on a larger scale.

Thanks

 

[John Vinson]

My question is, does establishing a form with potentially 50+ tabs and 30
subforms a cause for concern? Will the front-end lag horribly with this much
code and subforms on a single form?

Yes, and yes, in my experience.


John W. Vinson[MVP]

 

[Jesper Fjølner]

My question is, does establishing a form with potentially 50+ tabs and 30

subforms a cause for concern? Will the front-end lag horribly with this
much
code and subforms on a single form?

Yes in my experience with a larger database this is pretty slow.
If you do want to do it, you could keep the recordsource of all subforms to
nothing until you enter the tab and then load the recordsource.

Jesper Fjølner

 

[Albert D.Kallal]

Do notet that a sub-form is in fact a cntrol, and you can CHANGE what form
it displays.


So, in place of 50 sub-forms, you have ONE sub-form, and hten can set that
to display whatever form you want.

me.mysubcntorl.SourceObject = "frmCustomer"

So, your form will not laod 50, but oonly ONE sub-form. You use code to set
what frm you want to display...

 

[Justin]

This sounds like a good idea. I'll give it a try and post back if I run in
to any problems Thanks for the advice!