ACC2000: Seven Nested Subforms or Subreports Allowed in Access (214651)

The information in this article applies to:

Microsoft Access 2000

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.

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.

Modification Type:	Major	Last Reviewed:	6/28/2004
Keywords:	kbbug kbdocerr kbfix KB214651