Microsoft KB Archive/92676

From BetaArchive Wiki

Article ID: 92676

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q92676

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.


The subform is not linked to the main form.


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.


This behavior is by design.


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.


For more information about main form/subform relationships, search the Help Index for "linking subforms," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbprb kbusage KB92676