Question Search Querie using three Combo Box's

[Steve_T]

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

 

[ajetrumpet]

Filter by all three:

WHERE field1 = forms!FormName!Combo1 AND 
   field2 = forms!FormName!Combo2 AND 
      field3 = forms!FormName!Combo3

Filter 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)

 

[Steve_T]

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