>Hello,
>
>I am using ADO in my VB project. I have the need to do a find on a recordset, but I need to do this on more than one field. So my criteria is something like: "Field1='X' And Field2='Y'".
>The Find method fails on this as it uses more than one field. Is there a simple way to get around this?

You can't have more than 1 field in the find as you discovered. Some workarounds to it are:

-Use the Filter and then the Find (this can be really slow if you have a big recordset).
-Requery the database having your 2 fields in the Where clause.
-Concatenate your 2 fields as one when you first query the database and use the find on this new field.