Subforms... How many? 2

[HenryAnthony]

Hi,

How many subforms can be heirarchically linked in a one-to-many relationship using Access 2000? I found it once upon a time and searched help but can find no answer.

Best regards,

Henry

 

[PHV]

More than manageable, I guess.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GingerR]

Are you having a problem with a large number of subforms? I think I've used six or seven before.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[HenryAnthony]

PHV - If more than manageable, that will probably work for me. I thought I saw a definite number of levels though. Something like 10, which is more than I need.

GingerR - Not having a problem, just thinking about the design of a little database that would include a subform with six or seven levels. I did not want to go down that road to find out 4 was the limit.

Thanks for your responses!

 

[Lightning]

From the Access (XP) Help file:

Nesting levels

A main form can have any number of subforms if you place each subform on the main form. You can also nest up to seven levels of subforms. This means you can have a subform within a main form, and you can have another subform within that subform, and so on. For example, you could have a main form that displays customers, a subform that displays orders, and another subform that displays order details. However, a form will not display subforms in PivotTable or PivotChart view.

I believe that this was also the case in Access 2000.

HTH
Lightning

 

[HenryAnthony]

Thanks Lightning!

 

[TheAceMan1]

How are ya HenryAnthony . . . . .

In Access 2K, [blue]subforms nesting is limited to 3![/blue]

See Ya! . . . . . .

 

[HenryAnthony]

Thanks everyone for your comments. I've decided that any more than 2 nested subforms would be excessive from a user perspective. I think I can alter the design to achieve what I want without nesting tons of forms.

Best regards,

Henry