no data message

I

iccsi

"The openreport action was cancelled " message shows up when I set
report cancel is true.

Are there any way to let message does not show up?

Your help is great appreciated,
 
M

Marshall Barton

iccsi said:
"The openreport action was cancelled " message shows up when I set
report cancel is true.

Are there any way to let message does not show up?


Use error handling to trap and ignore error 2501 in the
Click event procedure of the form button used to open the
report. The general idea could be something like this air
code:

On Erro GoTo ErrHandler
. . .
DoCmd.OpenReport . . .
ExitHere:
Exit Sub

ErrHandler:
Select Case Err.Number
Case 2501
Resume Next
Case Else
MsgBox Err.Number & " - " & Err.Description
Resume ExitHere
End Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cancel = True - error 2
No Data in Report 2
No Data Problem 2
Open Report Action Cancelled 1
Can't view reports 2
The OpenReport action was cancelled 2
Annoying errer message 1
No data event 3

Top