Combo Boxes as multiple filters

[jleval]

I have four combo boxes that allow me to look up a record on my form based on the criteria within each combo box. What I would like to do is start my search in the first combo box. Once I select a criteria in the first combo box, I want my second combo box to have only the filtered from that first combo box. In a way, I want my search options limitted as I work my way from left to right in the combo boxes. Any ideas?

 

[boblarson]

That is called Cascading Combos.

A sample is located here:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip

 

[John Big Booty]

What you are looking for is a Cascading Combo Box set. Also search this forum on the subject for plenty of discussions.

 

[John Big Booty]

that is called cascading combos.

A sample is located here:
http://downloads.btabdevelopment.com/samples/combos/cascadingcombossample.zip

s n a p