Macro condition Select Object

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that selects several reports to run, after they run I change
the focus via SELECT OBJECT as a way to size the reports specifically so that
multiple reports are visible on the screen. In some cases, when there is no
data the reports will not run. I have a no data macro set up for that.
How do I setup a condition in the select object line of the macro that tells
the macro IF there is NO report skip this step?


Thanks
 
Eye,

One way would be to test the query that the report is based on, if it
returns any records. In other words, the Condition of the macro action
would be like this...
DCount("*","YourQuery")>0
 
Back
Top