I am having the same problem.
Here is my code that the Debug has identified to be the problem.
If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then
lngMyEmpID = Me.cboEmployee.Value
i think the problem has something to do...