I have a report that is being generated by many different users. They are looking up inventory based on multiple criteria. I have set up a series of combo boxes on a form and want to use them as the filter criteria for the report. I have the report based on a query and I put the combo box reference in the criteria field of the query design. My problem is that sometimes people will want to filter on all the criteria and other times only one or two criteria. I tried to use an iif statement in the criteria like :
IIf(([Forms]![frmFilter]![cmbGrade])="","like *",[Forms]![frmFilter]![cmbGrade]")
but I get no results when the field is blank. When I have something selected in the form everything works well.
My question is how do I filter for only non null selections from a series of combo boxes on a form?
IIf(([Forms]![frmFilter]![cmbGrade])="","like *",[Forms]![frmFilter]![cmbGrade]")
but I get no results when the field is blank. When I have something selected in the form everything works well.
My question is how do I filter for only non null selections from a series of combo boxes on a form?
