Open a report only if query has some records

[Ganymede]

I have one button on a form that opens two reports (unconditionally). I'd like to have the button open two additional reports, but only on the condition that the record source for the two additional reports (both queries) has some records. So the button will open between 2 to 4 records depending on whether the queries for the two additional reports have any records. My question is how do I create a macro that only opens a report when its control source has records.

[pbaldy]

You don't really have to check for data. You can use the No Data event of the report and in it have:

Cancel = True

You will need to trap for the resulting error, so I'd use VBA code rather than a macro, and include error handling:

http://www.baldyweb.com/ErrorTrap.htm