Nomatch property in ADO

[jbrowne]

Hi Folks,
Can anyone tell me what is the equivelent of the nomatch property (DAO) when using ADO. If, as I suspect there is none, what is the best way of coding around it ?
Thanks

John B

 

[swilliams]

As far as I am aware, you can also use NoMatch wih recordset created using ADO.

Simon

 

[Durkin]

What happens when there is no match found for a is that the recordset ends up at the end of itself, so just use the .EOF property to see if a match was found. Durkin
alandurkin@bigpond.com

 

[caf]

Hi

Here's some code

With rsSomeRecordSet
.Find blah blah blah

If .EOF Then
'No Match
Else
'Do ya stuff
End If
End With