I have a report that work with one record at anytime. But I want to alternate the record source base the status of checkbox on a form where I open the report.
If the check box is checked, then the report.recordsource = table1
else
the report.recordsource = table2.
Is it possible ? Please help...