Checkbox to sort records

[homerj56]

Using Access 2003. I have a form called frm_Report_Selection which has two buttons to launch two different reports, each with its own query. No problem there. I wish to add a check box to this form that when checked, will only send open records to the report. The report is based on qry_Report_Summary and has a field called Status1. This field's value is either Open or Closed. So, I check the box on my form and only those records whose Status1=Open are sent to the report (via on-click event on the frm_Report_Selection). Thanks!

[pbaldy]

I would probably use If/Then code and this technique:

BaldyWeb wherecondition

In other words, test the checkbox and restrict the records if checked.