one combo box affecting another

Sean_Sean

Registered User.
Local time
Today, 03:33
Joined
Jan 24, 2002
Messages
16
how can I limit the contents of one combo/list box based on what's selected in another combo/list box?

i have tried many methods none of which have worked so far, please help.
 
You can.

Right click on the second combo. Choose properties, then data. Goto the RowSource and hit the build button next to it. Start the query builder. On the grid make sure you put the fields you want to show. The first one should be the field you want to link the combo to the first one. In the criteria line for this field, put:

=Forms!frmFormName!FirstComboBoxName

Then, on the AfterUpdate event of your first combo, choose code builder and put this:

DoCmd.RunCommand acCmdRefresh

If you have difficulties, let me know and I will send you a demo.
 

Users who are viewing this thread

Back
Top Bottom