Hi all,
I have a querie that pulls together two tables, i need to filter the querie using what is selected by using three perameters in Combo box's.
I understand this is simular to a cascading querie but its not one as the value's of the combo boxs does not alter in anyway after the previous one is selected.
Any help or suggestions would be great but a sample would be perfect as i am a novice in the world of Access.

Thanks

Filter by all three:WHERE field1 = forms!FormName!Combo1 AND
field2 = forms!FormName!Combo2 AND
field3 = forms!FormName!Combo3Filter by any of the three:WHERE (field1 = forms!FormName!Combo1 OR
forms!FormName!Combo1 IS NULL) AND
(field2 = forms!FormName!Combo2 OR
forms!FormName!Combo2 IS NULL) AND
(field3 = forms!FormName!Combo3 OR
forms!FormName!Combo3 IS NULL)

Thanks a lot that works fine, simple when you know how!