psueoc
asked on
MS Access Error: This action or method equires a Module or Procedure Name argument.
The event calls the module.function successfully but after the control is passed back to the event code it returns this error:
"This action or method equires a Module or Procedure Name argument."
Here is the Code:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
'EPM Check Post Process Status
'DoCmd.OpenQuery "EPM_PROD_Get_IBIS_Success _Totals_By _Date"
DoCmd.OpenModule (Module1.ParamSPT2("2011-0 3-02"))
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
"This action or method equires a Module or Procedure Name argument."
Here is the Code:
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click
'EPM Check Post Process Status
'DoCmd.OpenQuery "EPM_PROD_Get_IBIS_Success
DoCmd.OpenModule (Module1.ParamSPT2("2011-0
Exit_Command15_Click:
Exit Sub
Err_Command15_Click:
MsgBox Err.Description
Resume Exit_Command15_Click
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've never used that other syntax - so I don't know the issues it may have. I like Call because it explicitly lets me know I'm referencing a Function.
mx
mx
ASKER
Thanks for your help.