Limit to amount of forms

A

Alastair

Dear All,

Is there a limit to the number of sub forms that can sit
on a form (not linked through child and master) in Access
2000? They are not related forms. I just show a different
sub form given a varying set of choices.

I plan to have about 20. Is it just limited to the
capabilities of a machine? Does the main form become slow
at startup or unstable?

There are probably other ways I could approach it but this
is my preferred option.

Thanks again...

Alastair
 
G

Guest

hi,
in access help, type specifications
a subform is a control in the toolbox. max number of
controls on a form is 754. but this could be further
limited by system resources.
 
J

John Vinson

Dear All,

Is there a limit to the number of sub forms that can sit
on a form (not linked through child and master) in Access
2000? They are not related forms. I just show a different
sub form given a varying set of choices.

I plan to have about 20. Is it just limited to the
capabilities of a machine? Does the main form become slow
at startup or unstable?

There are probably other ways I could approach it but this
is my preferred option.

Thanks again...

Alastair
Click to expand...

You might want to do a bit more coding work up front instead of
loading up this form with 20 subforms. It will be very slow to open.
You wouldn't want 20 subforms simultaneously visible in any case I'd
think (much too busy a screen).

It's quite straightforward to change the SourceObject property of a
Subform control in code based on your choices; this would give the
user the flexibility they need without the excessive overhead of
loading up 19 forms that you don't need.

I'm curious - how do these forms differ? Are they all of different
structure? based on different tables? or what? (No answer required
unless you're willing to assuage my curiosity!)

John W. Vinson[MVP]
 
A

Albert D. Kallal

I wrote a calendar form to display information in a calendar format, and
that means I had 7 x 5 = 35 sub-forms.

The form loaded near instant...so, 35 sub-forms is possible..and did not
cause any problems for me...
 
A

Alastair

Thanks for the feedback John,

The main form is a menu system where the user selects a
button on the left hand side of the form and the desired
subform appears on the right hand side.

Each form is a different size and with varrying data
sources used. I could use the SourceObject for the subform
and create an array for the dimensions. I think this would
work.

Do you forsee any problems with this approach or any other
properties I would need to watch out for?

Tanks again.

Alastair
 
J

John Vinson

Thanks for the feedback John,

The main form is a menu system where the user selects a
button on the left hand side of the form and the desired
subform appears on the right hand side.

Each form is a different size and with varrying data
sources used. I could use the SourceObject for the subform
and create an array for the dimensions. I think this would
work.

Do you forsee any problems with this approach or any other
properties I would need to watch out for?
Click to expand...

If none of them have master/child relationships to the mainform, and
if you can work around the size issue (which I haven't dealt with), it
sounds like a good approach to me. As noted elsethread, it's certainly
*possible* to have many subforms on a form; limiting the number does
improve performance, though, especially if the subforms have large
recordsources.

John W. Vinson[MVP]
 
Top