Search string type mismatch have tried everything

[Gina Maylone]

Hello!

I have a combobox with 3 columns, ownername, lotnumber and loanid, to be used to choose a loan record. In the after update event I have

DoCmd.SearchForRecord , "", acFirst, "[fullName] = " & "'" & Combo134.Column(0) & "'" & _
" and [lot_number] = " & "'" & Combo134.Column(1) & "'" And [LoanID] = (Combo134.Column(2)

It works perfectly without the last criterion, [LoanID] = (Combo134.Column(2). I have tried various combinations of quotes, single quotes, no quotes. Etc. LoanID is a number. Name and lot number are text.

I'm getting Runtime Error 13 - Type Mismatch. What am I missing Please? TIA!

[June7]

Not correctly concatenating the LoanID field and combo and can simplify the concatenation. Extra paren in front of Combo134.

DoCmd.SearchForRecord , "", acFirst, "[fullName] = '" & Combo134.Column(0) & _
"' And [lot_number] = '" & Combo134.Column(1) & "' And [LoanID] =" & Combo134.Column(2)

[Gina Maylone]

Thank you June7 for trying, still getting Type Mismatch. Using:

DoCmd.SearchForRecord , "", acFirst, "[fullName] = " & "'" & Combo134.Column(0) & "'" & _
" and [lot_number] = " & "'" & Combo134.Column(1) & "'" And [LoanID] = " & Combo134.Column(2)"

[June7]

You are not concatenating. Why do you have quote mark at the end?

DoCmd.SearchForRecord , "", acFirst, "[fullName] = " & "'" & Combo134.Column(0) & "'" & _
" and [lot_number] = " & "'" & Combo134.Column(1) & "'" & " And [LoanID] = " & Combo134.Column(2)

You could copy/paste my first suggestion.

[Gina Maylone]

Access put that last quote in there - I even erased it and it put it back. UGH. Anyway, I got it now.

DoCmd.SearchForRecord , "", acFirst, "[fullName] = " & "'" & Combo134.Column(0) & "'" & _
" and [lot_number] = " & "'" & Combo134.Column(1) & "'" & " And [LoanID] = " & Combo134.Column(2)

works beautifully. Thank you June7!

[June7]

Yes, Access was trying to be helpful because the quotes weren't balanced - must be in pairs.