I Created a table called tblTracking to track log ins and outs based on users login. then i created two queries, one is Append [QryLogInTime] and the other Update [QryLogOutTime]. I get Compile error: method or data member not found! after I login to the main form.
I have this code in Load event on the main form:
Can someone please help me find the issue? Thank you.
I have this code in Load event on the main form:
Code:
Private Sub Form_Load()
Dim User As String
Me.txtUser = Me.txtUserName
Me.txtLogin = DLookup("UserName", "tblUser", "UserLogin ='" & User & "'")
Dim strDocName As String
strDocName "QryLogInTime"
DoCmd.OpenQuery strDocName, acViewNormal, acEdit
End Sub
Can someone please help me find the issue? Thank you.