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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Combo Box FindNext 7
lost focus...? 3
ADO Recordset and FindFirst Problem 3
MSAccess 2000 -- Error 91 problem 7
Go To Record 1
FindFirst error 3
After Update Question 3
Requery/bookmark 4

Back
Top