Checkbox as report criteria

[cpgospi]

Hi all,

Not sure if I'm overlooking something simple here:

I'm using a checkbox on a form as criteria for a report. If the user does not make a selection, I'd like to display all records. It's essentially for open/closed/all invoices.

On form open I set the checkbox to Null.

I'm trying to use this logic in the criteria (in the report's query)

Iif (Forms!frmManagement!chkOpen IsNull, all records , Forms!frmManagement!chkOpen)

Any ideas are greatly appreciated...been kicking this around way too long.

Chris

 

[pbaldy]

Try this:

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

 

[cpgospi]

Exactly what I needed.

Thanks very much!

Chris