Don't want report to run when there are no records that meet the criteria

[Gan]

I have a report that I do not want to execute in cases if there are no records that meet the criteria. It returns a blank record if the criteria i not met and it prints garbage.


Thanks for your help.

[pbaldy]

Generally in the report's no data event:

Cancel = True

and you need to trap for the resulting error in the code that opens the report:

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