ADO Recordset and FindFirst Problem

[Eddy]

Does the FindFirst method work with an ADODB recordset?
I am using the following code to find a field in tbl1 recordset matching the
variable strRef.

Dim rs As New ADODB.Recordset
strRef = Field1
Set db = CurrentDb()
rs.Open "tbl1", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
rs.FindFirst "Field1 = '" & strRef & "'"

I get an error Method or Data Member not Found.
Is there a similar method for ADO recordsets that does the same thing as
FindFirst?
I am using Access2003
Thanks

 

[Brendan Reynolds]

An ADO recordset doesn't have a FindFirst method, it has a single Find
method. One of the arguments to the method specifies the search direction.
See Find Method (ADO) in the help file for details or check it out in the
MSDN library at the following URL ...

http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthfindmethodado.asp

 

[Eddy]

Thanks for the quick reply. One other question. How to you test for the
existence of a record? I am having no luck with the rs.NoMatch method
and don't see a similar alternative (Doesn't mean it's not there)
Thanks

 

[Brendan Reynolds]

Answered in other thread ("ADO Find Issues").