Combo Box based on another Combo Box.

G

Guest

I have a combo box that has a list of manufacturers as the Row Source, I just
typed in the list.
The 2nd combo box is where the Device name is chosen.
What I want is when the user selects "Canso" as the manufacturer, the 2nd
combo box will give them a choice of either 3100 or 4345...if they choose
"Rook" as the manufacturer, the 2nd combob box will give them a choice of
e2044 or e2045, and so on.
I'm kinda new at this, so be gentle?
Thanks,
Gee...
 
G

Guest

Wow...so much for a simple if/then statement.
Thanks for the help.


Ofer said:
In the RowSource Property of the first combo you have a select sql
"select A,B From Table1"

In the RowSource Property of the second combo you enter a select sql with a
filter
"select A,B From Table2 Where MyFieldName = forms![FormName].[Combo1Name]"

In the after update event of the first combo refresh the second combo.
by entering the code
me.combo2Name.requery




Gee... said:
I have a combo box that has a list of manufacturers as the Row Source, I just
typed in the list.
The 2nd combo box is where the Device name is chosen.
What I want is when the user selects "Canso" as the manufacturer, the 2nd
combo box will give them a choice of either 3100 or 4345...if they choose
"Rook" as the manufacturer, the 2nd combob box will give them a choice of
e2044 or e2045, and so on.
I'm kinda new at this, so be gentle?
Thanks,
Gee...
 

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

Top