ACC: Subform Is Not Updated (92676)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q92676 Novice: Requires knowledge of the user interface on single-user computers.
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.
STATUS
This behavior is by design.
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 master 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 main form/subform relationships, search the
Help Index for "linking subforms," or ask the Microsoft Access 97 Office
Assistant.
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kbprb kbusage KB92676 |
|---|
|