Synchronize combo boxes

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

Using Win 7, Access 2003. I would like to synchronize two combo boxes so the
contents of the second combo box are limited to records related to the
selection in the first combo box. Need help please.
 
If the recordsource for the second combo-box is a query which uses the first
combo-box as a criterion on a specific field, this is simply done by adding
a line of code to the AfterUpdate event of the first combo-box to force a
requery action on the second combo-box.

HTH. If you need more detail, please ask ...

Rob
 
Download the sample "QueryByForm With Three Combo Boxes" from
http://accdevel.tripod.com/.

(It's in Access 97 file format, but any subsequent version should execute
it, as is -- you should not have to convert it, unless you wish to copy,
modify, and use the sample.)

Larry Linson
Microsoft Office Access MVP
 
Back
Top