I'm running multiple reports in a Macro (each report runs an underlying query selecting appropriate data) - if their is no data as a result of the query (which is possible) how do I stop the macro running the report so I can then go onto the next report.

You can probably use the "on no data" event of the report...

You can probably use the "on no data" event of the report...

Thanks Mailman - however - this appears not to work - I want the macro to stop i.e. don't print the report so I created another Macro to stop the report but it comes back with an error "This action can't be carried out while processing a form or report event" - any ideas?

With macro condition you can use DCount function to preview report if their is data as a result of the query.
For ex:
Dcount("*","QueryName")>0