I have a command button that when clicked calls a procedure. I'm getting the following error:
"Compile Error
Expected variable or procedure, not module"
The code for the button is:
Private Sub cmdChangesToRCEvals_Click()
Call ChangesToRCEvals
End Sub
The code for the module is:
Public Sub ChangesToRCEvals()
Dim strSQL As String
DoCmd.SetWarnings False
strSQL = "Delete from AssignedEvaluators"
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
EndSub
I have this same structure in other areas and it works. Any suggestions?
Thanks.
Anna Jaeger
iMIS Database Support
"Compile Error
Expected variable or procedure, not module"
The code for the button is:
Private Sub cmdChangesToRCEvals_Click()
Call ChangesToRCEvals
End Sub
The code for the module is:
Public Sub ChangesToRCEvals()
Dim strSQL As String
DoCmd.SetWarnings False
strSQL = "Delete from AssignedEvaluators"
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
EndSub
I have this same structure in other areas and it works. Any suggestions?
Thanks.
Anna Jaeger
iMIS Database Support