You don't have to create indexes and use seek method to locate a record in ADO. Just write a SQL statement as,
SELECT * FROM [table name] WHERE [field name]= '" & variable & "'
and execute it through a recordset then check whether the recordset is EOF or not. I hope this is what you wanted. please post if you need and help regarding this. It is better if you can explain the actual scenario