How to create and/or combination queries to display in a form

[Guest]

Hi,

User needs to be able to sort from any single combo box or any combination
of all 4 boxes

The results are displayed in a list box

I have been able to get results where the records have all combinations but
i can't seem to figure how to get single and combination sorts combine to
display.

cbo1: orgs
cbo2: states
cbo3: processes
cbo4: packagaging

For example:
User wants to be see any process w/wo packaging info
if packaging info then user wants to be select from the packaging combo box.

Same for the other combo boxes

Below is one of the criteria (the check box is clear) on the query source
that I am using
IIf(IsNull([Forms]![form1]![cboProcess]),[tmakorgprocess].[processtypeid],[Forms]![form1]![cboprocess])

There is a criteria for all of the combo box fields.
I have a query with a left join tha will give the data I need, but when I
put in the criteria for the form. All I have is records with all 4
combinations


Please, Please help.

 

[SteveS]

This site shows how to have several criteria in a query return records even if
one or more controls are null.

http://mvps.org/access/queries/qry0001.htm


If you still can't get it to work, paste the SQL of the query in a post so we
can see what the query look like.

HTH