Hello Everyone

Code:
If (IsNull(DLookup("[userlogin]", "Login", "[userlogin]= '" & Me.txtLoginID.Value & "'" And _
(IsNull(DLookup("[userPassword]", "Login", "[userPassword]= '" & Me.txtPassword.Value & "'")))))) Then

I apologize for not catching this before, but the nesting on this expression is ALL jacked up. There is NO WAY that the batch of right parentheses near the end of that is right. This expression SHOULD look something like this.

Code:
If 
  [COLOR="RoyalBlue"]([/COLOR] IsNull[COLOR="SeaGreen"]([/COLOR] _
      DLookup( "[userlogin]", "Login", "[userlogin]= '" & Me.txtLoginID & "'" [COLOR="seagreen"])[/COLOR][COLOR="royalblue"])[/COLOR] _ 
Or _
   [COLOR="royalblue"]([/COLOR] IsNull[COLOR="seagreen"]([/COLOR] _
      DLookup(" [userPassword]", "Login", "[userPassword]= '" & Me.txtPassword & "'" [COLOR="seagreen"])[/COLOR][COLOR="royalblue"])[/COLOR] 
Then
   <bad thing>
Else
   <good thing>
End If


Thanks I'll give it a try.
 

Users who are viewing this thread

Back
Top Bottom