Syntax error in a Where Statement

[Leventcos21]

I am having a problem with adding an AND into the WHERE below. The user has can not login unless they USERID matches and there PERMISSIONID which has already been assigned.



This works but I want to add an AND into the statement.

("SELECT tblemployees.EmployeeID AS PersonID, tblemployees.permissionid " & _
"FROM tblemployees " & _
"WHERE UserID = '" & Me.txtUserID & _
"' AND PasswordTraining = '" & Me.txtPassword & "'", dbOpenSnapshot)

Thanks

 

[Leventcos21]

Sorry for the post, I see my error