Error: In Form -Run Command Action was canceled

[maic15]

Hi All,
I built a form in MS Access and placed a label on the form. When a user clicks on the label, the MS Access Report Wizard is displayed. Once the user is done building the report and clicks finish, I keep receivng the following error:
Error: In Form -Run Command Action was canceled

Here is my code for the label:

Private Sub Label1_Click()
DoCmd.RunCommand acCmdNewObjectReport
End Sub

 

[smozgur]

Hi maic15,

It is because an internal action is cancelled. It should response like that when you click Cancel when the Wizard is displayed.

You can control / by pass this error by using Error Handling like below:

Private Sub Label1_Click() 
On Error Resume Next
DoCmd.RunCommand acCmdNewObjectReport 
If Err then
  Msgbox "You have cancelled the wizard!"
End if
End Sub

You don't have to trigger an alert when error happens, so you can just remove Msgbox line. I put it to describe custom error handling

I hope it helps.

Suat