ACC2000: Subform Is Not Updated

ID: Q209771


The information in this article applies to:
  • Microsoft Access 2000

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

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


SYMPTOMS

When you scroll through records in the main form, the subform is not updated. The records on the main form and the subform are not synchronized.


CAUSE

The subform is not linked to the main form.


RESOLUTION

You should use the LinkMasterFields and LinkChildFields subform control properties to link the main form and subform automatically. You can manually update the subform by pressing the F9 (recalculate) key.


MORE INFORMATION

Recalculation occurs automatically for controls that reference other fields on the same form or fields in subforms. Recalculation does not occur automatically for subform controls that only reference fields on the main (master) form or in other subforms.

This is because subforms notify the main form of any changes, but the master form does not notify the subforms of changes. Nor do subforms on the same main form notify one another of any changes.


REFERENCES

For more information about linking main forms and subforms, click Microsoft Access Help on the Help menu, type "How Microsoft Access links main forms and subforms" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: prb

Keywords : kbdta FmsSubf
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: May 13, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.