ACC: Microsoft Access Changes LinkChild/Master Fields to Default (171177)


The information in this article applies to:

  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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.

MORE INFORMATION

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.
  7. View the property box for the subform and note that the LinkChildFields and LinkMasterFields properties display ProductID and EmployeeID, respectively.
  8. Click the subform control twice, and then click outside the subform control.
  9. Click inside the subform again and note the properties for the subform. The LinkChildFields and LinkMasterFields properties now display OrderId.

REFERENCES

For more information about creating subforms, search the Help Index for "Subform/Subreport Wizard," and then "create a subform."
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbbug kbusage KB171177
©2003 Microsoft Corporation. All rights reserved.