Invalid use of the Me keyword

This code is a function, not a private subroutine. I am suddenly getting this error using Me. [Field name here]. I don't get this error in my other code, just this one. Here's my complete code without the boring end part, but I get an error starting at the line:

Me.assignedby.Column(1)

Public Function AssignNullProjects() As Long

    Dim db As dao.Database
    Dim rs As dao.Recordset
    Dim strSQL As String

    assignedby = TempVars("user").Value

    Set db = CurrentDb
    strSQL = "SELECT CFRRRID FROM CFRRR WHERE assignedto Is Null"
    Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
    If Not rs.BOF And Not rs.EOF Then
        While Not rs.EOF
            strSQL = "UPDATE CFRRR SET assignedto = " & GetNextAssignee & ", assignedby = " & Me.assignedby.Column(1) & ", Me.Dateassigned = #" & Now & "#, Me.actiondate = #" & Now & "#, Me.Workername = " & _
                              Me.assignedto.Column(0) & ", Me.WorkerID = " & Me.assignedto.Column(0) & " WHERE CFRRRID = " & rs!CFRRRID
            db.Execute strSQL, dbFailOnError
            rs.MoveNext
        Wend
    End If

    rs.Close
    db.Close
    Set rs = Nothing
    Set db = Nothing

      

What is the possible cause of the above error and how can I remove it?

+3


source to share


1 answer


Place this code in the form's code module. When you try to use Me

in a standard module, you will always get a "Invalid use of the Me keyword" complaint.



Check "Invalid use of the Me keyword" and "Me <keyword"). See the topic in the Access help system for more details.

+1


source







All Articles