FindFirst method not found

  • Thread starter Thread starter aardvick
  • Start date Start date
A

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
 
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!
 
Back
Top