Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Run-time error 3464: Data type mismatch

    The arrowed line is the line Access wants debugged when I try to select a parcel number from a combo box in a form:

    Sub Combo46_AfterUpdate()
    ' Find the record that matches the control.
    ----> Me.RecordsetClone.FindFirst "[Parcel Number]=" & Me![Combo46]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    End Sub

    The data type of 'Parcel Number' is text. Is it single quotes? If so, where do they go? Or is something to do with a combo box?

  2. #2
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168

    Re: Run-time error 3464: Data type mismatch

    You need to change the arrowed line:

    Yours:
    ----> Me.RecordsetClone.FindFirst "[Parcel Number]=" & Me![Combo46]

    Change to:
    ----> Me.RecordsetClone.FindFirst "[Parcel Number]= '" & Me! [Combo46] & "'"

    This is because a text field is a string and needs to be in (as you said) in parenthisis.

    Hope helps.

  3. #3
    Join Date
    Jan 2003
    Posts
    3
    I believe that did it, thank you.

    Now it has moved to the next line with a run-time error 3022.

    Please see attached file.
    Attached Files Attached Files

  4. #4
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168

    Lightbulb I think.....

    Now it's 'cos (I think anyway, anyone please feel free to correct me) the bookmark has to be a number. Change the Parcel Text to a Number instead of text and try it.

    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •