Me.Recordset.Clone Error 3464

hello experts,

i'm using a macro to search a record  number.

Private Sub Texte503_afterUpdate()

    Dim rs As Object
    Set rs = Me.Recordset.Clone
     rs.FindFirst "[n°] = '" & Me![Texte503] & "'"

    If Not rs.nomatch Then
        Me.Bookmark = rs.Bookmark
    Else
     MsgBox "Aucun numéro correspondant!"
    End If
End Sub


Something is wrong with      rs.FindFirst "[n°] = '" & Me![Texte503] & "'"  access tell me me error 3464. type is incompatible.

what should i write then?

thks mafle
mafleAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
<< Dim rs As Object >>
should be either
Dim rs as DAO.Recordset <or> Dim RS as ADODB.Recordset

Also, make sure a reference is set to the 'Microsoft DAO Object Library' or 'Microsoft ADO Object Library' (go into any code module, Tools menu:References)

What's a n with the little circle?  This may be a non-standard character that's hosing this up.

Also, check what's in Me![Texte503] and make sure there's no single apostrope ( ' ) marks, as this will hose up anthing when it's fed into a string.

Hope this helps.
-Jim
0
 
mafleAuthor Commented:
good work!.

thks for you time,
mafle
0
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.