This article was previously published under Q214651
This article has been archived. It is offered "as is" and will no longer be updated.
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).
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.
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.
For more information about creating nested subforms and subreports, click Microsoft Access Help on the Help menu, type create one or more subforms in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.