Error in trying to limit report to print

[austenr]

I am trying to alter a macro to not print a report if a certain condition is true. When the macro that prints reports runs and gets to the report I do not want to print I get the following message:

You tried to run a VB procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation Operations.

So I'm guessing that you cannot exclude a report at the macro level?

:dunno

[mattj]

I suggest that you use VBA instead of a macro. Then just use an If statement to check your condition and skip the report.

HTH
Matt