ACC2000: Subdatasheets in Subform Cannot Be Expanded If First Record in the Subform Does Not Contain a "Child" Record (263629)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q263629
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

If you create a main form with a subform that contains subdatasheets, and the first record in the main form does not contain corresponding data in the related table, the expand indicator (+) for the subdatasheet is not visible.

Note This behavior does not seem to occur in Microsoft Access 2002 or Microsoft Office Access 2003.

RESOLUTION

For you to be able to view related data of any record in a subdatasheet in a subform, the first record in the main form must contain related data.

MORE INFORMATION

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Click the Customers table, and then on the Insert menu, click AutoForm. When the form is displayed, note that there are expand indicators in the subform. Save and close the form.
  3. Open the Customers table in the sample database Northwind.mdb and add a new customer as follows:

    CustomerID: AAAAB
    Customer Name: Microsoft Corporation

  4. Close the Customers table.
  5. Open the form that you created in step 2. Note that you do not see the expand indicator on any record in the subform, even after you scroll to a record that has related child records.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kbprb KB263629
©2004 Microsoft Corporation. All rights reserved.