Newbie: subform nesting

[Tony]

I am new to databases and Access. Currently using
Access97. Am I limited to a certain number of subforms a
form can have?

Ex. frmAssembly (main)
sfrmUnit (of frmAssembly)
sfrmPuchUnit (of sfrmUnit)
sfrm.....and so on

I think I understand a form can only have one subform. If
I have each subform containing a subform then, how many?
Does this make sense or am I out in left field?

Thanks!
Tony

 

[chas]

Hi Tony,

Access help suggests that you can 'nest' subforms to a
level of 7 deep (ie a subform within a subform within a
subform). The limit to the number of controls you can
have on a single form is 754.

For more info on Access' limitations search help
for 'specifications'.

hth

chas

 

[John Vinson]

I am new to databases and Access. Currently using
Access97. Am I limited to a certain number of subforms a
form can have?

Ex. frmAssembly (main)
sfrmUnit (of frmAssembly)
sfrmPuchUnit (of sfrmUnit)
sfrm.....and so on

I think I understand a form can only have one subform.

That's NOT the case... I'm working on a form right now with 42
subforms!

If I have each subform containing a subform then, how many?

Subforms can be nested three deep in Access97, seven deep in later
versions. However, I'd hesitate to present users with such a form - it
would get VERY busy and hard to manage. It's a bit more work but there
is a point where you really should pop up a new form (and I say this
as a strong and frequent advocate of using subforms!)