Combo boxes

[Paul]

I have a form, which includes 3 combo boxes. After
choosing a value from the first combo box I would like the
second combo box on the form to only display a subset of
values depending on what was chosen from the first combo
box. I would then like to repeat this with the results
from the second combo box dictating what will be available
in the third combo box.

Any help would be greatly appreciated

 

[Connel Valentine]

it depends on whether the combo box is accessing values
from the table or whether you typing in the values that
you want

 

[Terri Policy]

I want to do the same exact thing as Paul. In my case,
*all* of my combox boxes are backed by tables/queries.

So, once the user makes a selection from cbx1, the value
from the bound column of the query used by cbx1 needs to
be used in the where clause of the query used to populate
cbx2, and so on.

This seems like it would be a common thing to want to do,
yet I can't seem to figure out on my own how to do it.
So, any help anyone can offer would be greatly
appreciated.

 

[Paul]

The combo box is accessing values from tables - Combo box1
is populated from the primary table while Combo box2 is
then populated from a secondary table (e.g. if I choose
the car make of Vauxhall from the primary table I then
want the Combo box in the secondary table to only display
the makes Astra, Vectra, Corsa...)