ACC: Subform Is Not Updated

 Last reviewed: May 28, 1997
Article ID: Q92676
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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.

Keywords : FmsSubf kbusage
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.