Hi,

Ado Recordsets have a find method:

Find (criteria, SkipRows, searchDirection, start)

Look in the MSDN Library for more information on this method.

Or you could even use a query to return the record that you want:

SELECT * FROM tablename WHERE field=criteria.

HTH,

Preeti