Type mismatch error

[Kurt]

I am getting a type mismatch error on this code:

    If (IsNull(DLookup("[UserName]", "tblUser", "[UserName]='" & Me.cboUser.Value & "'" And Password = "'" _
    & Me.txt_Password.Value & "'"))) Then

What am I doing wrong here?

 

[james_lankford]

not positive but try changing

"[UserName]='" & Me.cboUser.Value & "'" And Password = "'" & Me.txt_Password.Value & "'")))
to
"[UserName]='" & Me.cboUser.Value & "' " And Password = "' " & Me.txt_Password.Value & "' ")))

 

[Micron]

I think the problem is that the password check is also wrapped in the IsNull function. I think this would be more correct:

If (IsNull(DLookup("[UserName]", "tblUser", "[UserName]='" & Me.cboUser & "'")) And Password = "'" _
& Me.txt_Password & "'"))) Then

I left off .value since it is the default for text boxes and combo boxes. My suggestion is based on the assumption that the data type for the password and username fields is text.