Combo to show all information.

[lars7]

Hi,
How do I get a combo box to show all records if the combo box that supplies it's information is blank. I know this was done recently but I can't find it. The second and third combos get criteria like this:

Second
[forms]![ReportForm]![txt1]
Third
[forms]![ReportForm]![txt1]
[forms]![ReportForm]![txt2]

But I would like the combos to show all records if "txt1" or "txt2" where blank but work as required to when there is a value in them.

 

[lars7]

Hi,
I found a way. For anyone with the same problem here is the Sql:

SELECT tbltruststaff.ChpLocation, tbltruststaff.Chp
FROM tbltruststaff
GROUP BY tbltruststaff.ChpLocation, tbltruststaff.Chp
HAVING (((tbltruststaff.ChpLocation) Is Not Null) AND ((tbltruststaff.Chp)=IIf([forms]![reportForm]![txt1] Is Null,[chp],[forms]![reportForm]![txt1])))
ORDER BY tbltruststaff.ChpLocation;