Print Macro

R

Richard

I am creating a macro that will print a number of reports.
But I can't seem to stop it printing out reports that has
no record. For these reports it just prints an empty page.

Any suggestions.
 
S

Steve Schapel

Richard,

One simple approach to this is to put a Condition in your macro for each
of the OpenReport actions, that checks whether there is data returned by
the query that the report is based on. It will look something like this...
DCount("*","YourQuery")>0
 
Top