Synchronize combo boxes

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.
 
R

Rob Parker

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
 
A

Access Developer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Trying to remove error from conflicting code 0
Dynamic Naming of Form Button 3
VBA office 365 on windows 10 0
Combo or list box 0
Combo box 0
synchronized Combo Boxes in subforms 2

Top