Preview Report Cancel

[howardjones]

I have some problem with cancelling a report once an error has occurred. I have trapped the error but I also need to stop the preview of the report

DoCmd.Close acReport, "RprQryTeamScores2"

this code give me a runtime error 2585 I need to suppress this messege and stop the report from preview.

Thanks for any help in advance

 

[jfischer]

To close the report after an error, put

DoCmd.Close

in your report's OnError event handler, after handling any error messages you may want to display.