Newbie: subform nesting

  • Thread starter Thread starter Tony
  • Start date Start date
T

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
 
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
 
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.
Click to expand...

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?
Click to expand...

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!)
 
Back
Top