Yes, this is very simple to set up in a form. I have something similar
working that allows the user to select among four or five different
combination boxes to limit the list. I use a command button for the user
to indicate the selections are complete and apply the filter criteria to
the list. It does get a bit complicated in the background, but it is
simple for the user.

-----------------------------------------------------------

-----------------------------------------------------------

Kieron:

To make the criteria optional, i.e. the user can select values from none to
five of them you need to test for each having a value or being Null.  Firstly
you need an unbound dialogue form with the 5 combo boxes and a button which
opens the query, or better still a form or report based on the query.  Then
in the query you reference each combo box as a parameter like so:

SELECT *
FROM MyTable
WHERE
(Field1 = Forms!MyForm!FirstCombo OR Forms!MyForm!FirstCombo IS NULL)
AND
(Field2 = Forms!MyForm!SecondCombo OR Forms!MyForm!SecondCombo IS NULL)
AND
(Field3 = Forms!MyForm!ThirdCombo OR Forms!MyForm!ThirdCombo IS NULL)
AND
(Field4 = Forms!MyForm!FourthCombo OR Forms!MyForm!FourthCombo IS NULL)
AND
(Field5 = Forms!MyForm!FifthCombo OR Forms!MyForm!FifthCombo IS NULL);

Ken Sheridan
Stafford, England