Hello Everyone (1 Viewer)

Djhilbert

Registered User.
Local time
Today, 02:31
Joined
Dec 26, 2011
Messages
17
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

Top Bottom