Parameters determined by combo boxs on forms

[shapman]

Hi All

I have set up a form to run a query. There are 3 main variables; 'Status', 'Substatus' and 'Publications'. The publications variable has multiple choices on the form as it is likely i will be sending out more then one publication at a time.
What I need to be able to do is that if a dropdown box is left empty it returns all fields of that variable but at the same time only those that are within the criteria set out by the other combo boxes.. i.e. status is left empty, but the query still runs and filters out those specific substatus and publication. I think this is becoming complicated because the publication criteria relys on five combo boxs.
So in short, how do i get a criteria to return all results for that field if the combo box is left empty but still filter the entire list by the other combo boxes.
I have tried setting the parameter in the criteria as "*" or forms.combobox1 etc but this doesnt really allow for the multiple selections for publictions!

help!, im a little lost.

many thanks in advance

Shapman,

 

[ajetrumpet]

So in short, how do i get a criteria to return all results for that field if the combo box is left empty but still filter the entire list by the other combo boxes.

You can't (if all results means all records)

A query's UNIT OF MEASURE is a record. That is why. You will have to use another setup.

 

[EMP]

See Jon K's basic criteria format and his Note (2) in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^