FindFirst method not found

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
 
A

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!
 

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

Top