ACC2000: Seven Nested Subforms or Subreports Allowed in Access

Article translations Article translations
Article ID: 214651 - View products that this article applies to.
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).

Expand all | Collapse all

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.

References

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.

Properties

Article ID: 214651 - Last Review: October 26, 2013 - Revision: 3.0
Applies to
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbdocerr kbfix KB214651

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com