ADO Find Issues

  • Thread starter Thread starter Eddy
  • Start date Start date
E

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
 
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
 
Back
Top