S swarv Registered User. Local time Today, 16:22 Joined Dec 2, 2008 Messages 196 Mar 28, 2009 #1 All, can somebody just glance an eye over the below and just state what the error is? Code: If Me.txtpassword.Value = DLookup("passwords", "tbl_users", "[tbl_users.user_id]=" & cboEmployee.Value) Then Thanks Martin
All, can somebody just glance an eye over the below and just state what the error is? Code: If Me.txtpassword.Value = DLookup("passwords", "tbl_users", "[tbl_users.user_id]=" & cboEmployee.Value) Then Thanks Martin
RuralGuy AWF VIP Local time Today, 09:22 Joined Jul 2, 2005 Messages 13,819 Mar 28, 2009 #2 If the [tbl_users.user_id] is text then: Code: If Me.txtpassword = DLookup("passwords", "tbl_users", "[tbl_users.user_id]='" & cboEmployee & "'") Then
If the [tbl_users.user_id] is text then: Code: If Me.txtpassword = DLookup("passwords", "tbl_users", "[tbl_users.user_id]='" & cboEmployee & "'") Then
gemma-the-husky Super Moderator Staff member Local time Today, 16:22 Joined Sep 12, 2006 Messages 16,072 Mar 28, 2009 #3 you might need extra spaces around the last = sign
