ADO Find Issues

[Eddy]

Using this Find method for an ADO recordset works but how do you know if the
record is found?

rs1.Find "[Field1]='strRef''"

Apparently the NoMatch method does not work with ADO recordsets and have
been unable to find alternative that functions with ADO (Doesn't mean it's
not there)
Thanks

 

[Brendan Reynolds]

If no match was found, the .EOF property of the recordset will be True.

 

[visdev1]

I think this is what you are trying to do.


rs1.MoveFirst
rs1.Find "[Field1]= '" & strRef &"'"

If Not rs1.EOF Then
'found match
end if