It'll only give you a runtime error if you don't trap the EOF.Quote:>I am used to use DAO findfirst method, which, if the criteria does not
>match, will return a nomatch message..
>However, I found ADO find method can't do that, it seem simply give an
>runtime error to me when it doesn't find anything based on the
>criteria...what should I do?
IF .EOF then
msgbox "Record Not found"
msgbox "Record Found!"
------- That type of thing...
I am have just started using ADO code and the ADO data control. Much to my
surprise, however, I could not find the familiar FindFirst method that I
used to use with DAO. Could somebody please help me find the ADO equivalent
of this method so that I can search through a recordset?
Thanks in advance,