ACC: Using Code to Dynamically Synchronize Two Forms (95/97) (149940)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q149940 SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article shows you how to use Visual Basic for Applications to
synchronize a form to the current record on the subform of another form.
The method described in this article synchronizes the form's bookmark with
the bookmark of the form's recordset after searching the recordset for
the current key value from the other form's subform.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
NOTE: This article explains a technique demonstrated in the sample
files, FrmSampl.exe (for Microsoft Access for Windows 95 version 7.0)
and FrmSmp97.exe (for Microsoft Access 97). For information about how
to obtain these sample files, please see the following articles in the
Microsoft Knowledge Base:
150895
ACC95: Microsoft Access Sample Forms Available in Download Center
175066
ACC97: Microsoft Access 97 Sample Forms Available in Download Center
REFERENCES
For more information about synchronizing forms with Microsoft Access 2.0,
please see the following article in the Microsoft Knowledge Base:
119398
ACC2: Using Code to Dynamically Synchronize Two Forms
For more information about the SysCmd() function, search for "SysCmd
Function" using the Microsoft Access 97 Help Index.
For more information about the Me property, search for "Me Property"
using the Microsoft Access 97 Help Index.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming kbusage KB149940 |
---|
|