ACC: How to Synchronize Two Combo Boxes on a Form (97624)
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 Q97624
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article shows you how to synchronize two combo boxes so that
when you make a selection in the first combo box, the selection limits
the choices in the second combo box.
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 combo boxes, search for
"synchronize," and then "synchronizing combo boxes" using the Microsoft
Access Help Index.
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbhowto KB97624 |
---|
|