Button error during creation

[cdl1701]

I am trying to set up a button to run a macro that opens a report... but when I get to the end of the wizard and pick finish I get this "Method 'Module' of object '_Form_JW-CONSTRUCTION' failed". It will not let me create the button. The macro, report and Query run fine. What am I doing wrong?

Thanks,
Chris

 

[Gnism]

Hello Chris,
What does the code on your button look like? It should look similar to this:
===========================================
Private Sub YourButtonName_Click()
On Error GoTo Err_YourButtonName_Click

Dim stDocName As String

stDocName = "Macro1"
DoCmd.RunMacro stDocName

Exit_YourButtonName_Click:
Exit Sub

Err_YourButtonName_Click:
MsgBox Err.Description
Resume Exit_YourButtonName_Click

End Sub
===========================================

Hope this helps - Gnism.