Microsoft KB Archive/214651

= ACC2000: Seven Nested Subforms or Subreports Allowed in Access =

Article ID: 214651

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q214651



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
The Microsoft Access 2000 "Form and report specifications" Help Topic contains the following specification:   Number of levels of nested forms or reports       3 The Help Topic "Subforms: What they are and how they work" contains the following statement:   You can also nest up to ten levels of subforms. Both items are incorrect.



RESOLUTION
Access 2000 allows seven nested subforms or subreports. That is, the main form has a one-to-many relationship with the first subform, and the first subform has a one-to-many relationship with the second subform, and so on, for a total of eight forms, including the main form.

