ACC2000: Subform Is Not Updated (209771)
The information in this article applies to:
This article was previously published under Q209771 Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to 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.
REFERENCESFor 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.
| Modification Type: | Minor | Last Reviewed: | 7/13/2004 |
|---|
| Keywords: | kbprb KB209771 |
|---|
|