ACC: MS Access Changing LinkChild/Master Fields to Default

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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."

Keywords          : FmsProp FmsWizm kbusage
Version           : 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbbug
Solution Type     : Info_Provided