RunTime error 3464 data type mismatch string

Running into issue with data mismatch at: .FindFirst "[strClientId] = " & vID.  CboTest is a text string.

Dim vID As String

vID = cbotest

    If Not IsNull(vID) Then
        With Me.RecordsetClone
            .FindFirst "[strClientId] = " & vID
            If Not .NoMatch Then
                Me.Bookmark = .Bookmark
            End If
        End With
    End If

Error occurs at: .FindFirst "[strClientId] = " & vID
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I assume that "strClientID" is a Text field, so do this:

.FindFirst "[strClientId] = '" & vID & "'"

This surround the vID value with single quotes ( ' )
jbakestullAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.