Find Record Problem

[indesisiv]

find record problem

I am using a simple search to goto specific records but.

Dim rs As Object
Set rs = Me.RecordsetClone
rs.FindFirst "[IDCode] = " & "'" & strPersonIDSelect & "'"
Me.Bookmark = rs.Bookmark


I have a couple of records with a " ' " in them and it appears to break up the string.

So this just comes up with an error - missing operator and highlights the findfirst line.

Is there a way to work around this. I have to search on this field!!!

Anyhelp will be greatfully received.

Steve

 

[Mile-O]

Re: find record problem

        Dim rs As DAO.Recoset
        Set rs = Me.RecordsetClone
        rs.FindFirst "[IDCode] = """ & strPersonIDSelect & """"
        Me.Bookmark = rs.Bookmark

 

[indesisiv]

Thanks a lot mile - Works like a charm!!

 

[Mile-O]

Even with my bad spelling of Recordset?

 

[indesisiv]

I didn't notice ...
I musta put it in correct when i typed it in automatically ...
Either that or i can't read properly!!