Hi, all -
I'm getting "Compile error: Method or Data Member not found" when running a simple code.
Here's the code:
Private Sub btnOK_Click()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("tblEmployeeList", dbOpenSnapshot, dbReadOnly)
rs.FindFirst "UserName='" & Me.[txtUserName] & "'"
The error highlights "me.[txtUserName] although the "txtUserName" was an option when writing "me.".
Not sure where to go next.
thanks.
I'm getting "Compile error: Method or Data Member not found" when running a simple code.
Here's the code:
Private Sub btnOK_Click()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("tblEmployeeList", dbOpenSnapshot, dbReadOnly)
rs.FindFirst "UserName='" & Me.[txtUserName] & "'"
The error highlights "me.[txtUserName] although the "txtUserName" was an option when writing "me.".
Not sure where to go next.
thanks.