Clayhead22
Registered User.
- Local time
- Today, 04:53
- Joined
- Feb 22, 2015
- Messages
- 36
I have created a Lookup function and i have used this exact layout before and it has worked however this time i get a data mis-match. Can anybody see where i have gone wrong?
I am hoping its something simple i have missed although can not spot.
Code:
If (IsNull(DLookup("[Username]", "Users", "[Username] ='" & Me.Username.Value & "' And [Date of Birth] = '" & Me.Date_Of_Birth.Value & "' And [Email] = '" & Me.Email.Value & "' And [Mobile] = '" & Me.Mobile.Value & "' And [Postal Code] = '" & Me.Post_Code.Value & "'"))) Then
MsgBox "Incorrect Details Entered"
Else
I am hoping its something simple i have missed although can not spot.