Unanswered: where clause from combobox
I have a combobox in which i can pick a number of values. I also have a query which gets it's where clause from this combobox. The problem is that I also want to be able to pick no value at all in the combobox and that the where clause of the query remains empty and just selects everythig . I have tried to do this by putting this:
IIf(is null([Forms]![frm_reconciliation]![Combo1])=true; Like "*";[Forms]![frm_reconciliation]![Combo1])
in the where clause of the query but it does not work. If I don't pick a value the query will return nothing.
Nobody dies a virgin because life screws us all!