tblanswers
answer
Is where the answer comes from. My DLookup is wrong!
Code: Select all
If IsNull(DLookup("[UserID]", "tblUserSecurity_Sec", "[UserID]='" & Me.UserID.Value & "' And [answer]='" & Me.answer.Value & "'")) Then
Code: Select all
If IsNull(DLookup("[UserID]", "tblUserSecurity_Sec", "[UserID]='" & Me.UserID.Value & "' And [answer]='" & Me.answer.Value & "'")) Then
Code: Select all
If IsNull(DLookup("[UserID]", "tblUserSecurity_Sec", "[UserID]='" & Me.userID.Value & "' And [pw]='" & Me.txtyouranswer.Value & "'")) Then