how to close a no data report

[gingergina]

If my client's data range contains no data, and he opens a report...an obnoxious built in message says "no data". Despite adding cancel=-1 to open report method, it crashes. How do I have it: if a report has no data, I wish the report (with code you advise me) to close the report-how do I do this??

 

[Rich]

Use the NoData event on the report
ie MsgBox "NoData"
Cancel = True