How to synchronize two combo boxes on a form in Access 2002 or in Access 2003 (289670)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
This article was previously published under Q289670 Moderate: Requires basic macro, coding, and interoperability
skills. This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp). For a Microsoft Access
2000 version of this article, see
209595. For a Microsoft Access 97 version of this article,
see
97624. SUMMARY
This article describes how to synchronize two combo boxes so that when
you select an item in the first combo box, the selection limits the choices in
the second combo box. Note This article explains a technique that is demonstrated in the sample
file, FrmSmp00.mdb.
For additional information about how to obtain this
sample file, click the following article number to view the article in the
Microsoft Knowledge Base: 233324
ACC2000: Microsoft Access 2000 Sample Forms Database Available in Download Center
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbProgramming KbVBA kbhowto KB289670 |
---|
|