G
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.
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.