Cancel = True without the Access notification

[GraeagleBill]

Private Sub Report_NoData(Cancel As Integer)
MsgBox "No checks were found recorded for week " & Me.OpenArgs
Cancel = True
End Sub

The message displays as expected and the report closes but I can't get that action to take place without Access "telling me the action was cancelled". What else do I need?

[pbaldy]

Error trapping in the code that calls the report. It will throw a 2501 error, which since you have a message already you just have it resume with the exithandler.

[GraeagleBill]

Thanks Paul. I'm scratching my head as to why I haven't hit this before. Memory really in the tank these days so I guess I shouldn't be surprised.

I have a lot of extra snow if you're running out?

[pbaldy]

No problem Bill. Feel free to bring as much snow as you can fit in your car.