Compile Error-Expected variable or procedure, not module 1

[ajaeger]

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

http://www.axcedesolutions.com

 

[jebry]

Hi!

What is the name of the module that the function is in? If it is the same as the function then change it by adding mdl in front of it.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[ajaeger]

Thanks. That worked.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com