FindFirst method not found

[aardvick]

I'm trying to use the .FindFirst method on a recordset clone using very
generic code, but neither .FindFirst or .NoMatch are recognized. Help?

Dim rs As Recordset
Dim strFind as string
Set rs = Me!RecordsetClone
strFind = Me!txt_Find
rs.Findfirst "[LastF] = " & strFind
If rs.Nomatch Then
MsgBox "No matches found.", vbOKOnly
Else
Me.Bookmark = rs.Bookmark
End If

 

[Allen Browne]

Try:
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone

Also, if LastF is a Text field (not a number field), you need extra quotes:
rs.Findfirst "[LastF] = """ & strFind & """"
Explanation of the quotes:
http://allenbrowne.com/casu-17.html

 

[aardvick]

Hi Allen,
Thank you very much for your response. I had tried to use DAO.recordset,
but that also was not recognized by Access - I got a compile error on the Dim
statement. Then I found my answer in a post from way back in 5/2005:

.....you will need to go into References (Tools|References) in
the code editor and place a check next to Microsoft DAO 3.6 Object Library.
(Wayne Morgan, MS Access MVP)

Problem solved!
-Aardvick

PS - Thanks also for the tip about the extra quotes - I'm still kinda new to
this!