Microsoft KB Archive/263629

= ACC2000: Subdatasheets in Subform Cannot Be Expanded If First Record in the Subform Does Not Contain a &quot;Child&quot; Record =

Article ID: 263629

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

 Open the sample database Northwind.mdb. 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. Open the Customers table in the sample database Northwind.mdb and add a new customer as follows:

CustomerID: AAAAB

Customer Name: Microsoft Corporation

 Close the Customers table. 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.</ol>

Additional query words: prb plus sign plussign

Keywords: kbprb KB263629

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.