Microsoft KB Archive/171177

= ACC: Microsoft Access Changes LinkChild/Master Fields to Default =

Article ID: 171177

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q171177



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
The LinkChildFields and LinkMasterFields properties that are set by the Subform/Subreport Wizard are reset to the default when the subform control is clicked twice.

This behavior also occurs if you manually change the LinkChildFields and LinkMasterFields properties.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.



Steps to Reproduce Problem

 * 1) Open the sample database Northwind.mdb.
 * 2) Create a new form in Design view based on the Orders table.
 * 3) Move the form to the right to display the Database window. Click the Tables tab and drag the Order Details table onto the form to create a subform.
 * 4) When the Subform/Subreport Wizard appears, click the Define My Own option on the first screen of the wizard.
 * 5) In the Form/Report Fields list box, select EmployeeID.
 * 6) In the Subform/Subreport Fields list box, select ProductID, and then click Finish.

A new Order Details subform appears on the main form.
 * 1) View the property box for the subform and note that the LinkChildFields and LinkMasterFields properties display ProductID and EmployeeID, respectively.
 * 2) Click the subform control twice, and then click outside the subform control.
 * 3) Click inside the subform again and note the properties for the subform. The LinkChildFields and LinkMasterFields properties now display OrderId.

