ADO version of .nomatch method? (1 Viewer)

[directormac]

Hey All - My recent silence has been caused by trying to convert a db from DAO to strictly ADO. All is going fairly well so far, but I've hit a snag and am under deadline pressure...

Can anyone give me the skinny on the ADO equivalent for DAO's delightful .nomatch method? Trying to run a .find method on the currently open recordset and would like to check for the chance that no records matching the criteria string exist...

DAO is easy, "if rst.nomatch then...", what is the ADO version?

big, big TIA

--Puzzled Mac

 

[directormac]

Ignore me, sleep deprivation has killed my brain. I'm going to apply my nice little .filters instead of using .find, then check the .recordcount

--Sheepish Mac

 

[Jack Cowley]

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "MyTable", CurrentProject.Connection, adOpenKeyset

rs.MoveFirst

rs.Find "[MyID] = " & Me.MyTextField

If (rs.BOF = True) Or (rs.EOF = True) Then
Data not found
Else
Data found so do something
End If