Query with combo on form for parameter

[jwleonard]

I have a report query that uses a combo box on a form to collect the parameters. I would like to be able to include an option that would be like not having any criteria at all, to show all the records. I have tried several combinations in the criteria to get it to work and haven't found a way yet.

IIf([Forms]![MyForm]![Mycbo]<0,Like"*",[Forms]![MyForm]![Mycbo])

I have tried various different versions of what you see above and none have worked. The true part and the false part both work if separated and tested. Is it possible to make this work or is there better way to do this?

 

[pbaldy]

One way:

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

 

[jwleonard]

Thanks, that did it! I swear sometimes the simplest things mess me up the worst.