I have the following code
Code:
'Check value of password in tblEmployees to see if this matches value chosen in combo box If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", "[lngEmpID]=" & Me.cboEmployee.Value) Then lngMyEmpID = Me.cboEmployee.Value