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.