Combo Boxs

[clean32]

If i had a form based on a table.


a combo box on this form based on an other table
the form records are filtered on this combo box

All OK so far.

now since i have to many records i wish to further filter down by using another combo box.

so the filter order will be combo1, combo2 filters off combo one. the form filters off combo 2.

no i have the record source on the form set to combo2.

but i am not having much luck getting combo 2 to filter off combo 1.

well it will filter but only the first time and then will not change after that

cheers

[orange]

The topic is called Cascading Combo boxes
There are free video tutorials here that should help.

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[clean32]

The topic is called Cascading Combo boxes
There are free video tutorials here that should help.

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Brilliant and thanks

so all i needed to do was use "where" in the filter