Find using SQL and ADO?

I am using VB6 with Access2002 and ADO2.6

I have used DAO with some sort of SQL string to do a find. Problem is that was a while ago now and with Access2002 I’m pretty much forced into using ADO.

So can someone give me a basic example of how to find a record by a field. And am I able to use SQL, or, is there another way.

I am using a recordset which has been set by an ADODC.

Thanks for your time