Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Seven Nested Subforms or Subreports Allowed in Access

ACC2000: Seven Nested Subforms or Subreports Allowed in Access

View products that this article applies to.

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).

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB214651, kbdocerr, kbfix, kbbug

↑ Back to the top

Article Info
Article ID : 214651
Revision : 2
Created on : 6/28/2004
Published on : 6/28/2004
Exists online : False
Views : 333