Hi,
I'm creating a database application that uses a MS Access Database, I'm using ADO to open the connection and Recordset. If I have a recordset already opened, What is the fastest or best best way to find a specific Record.


Example...

* If I wanted to search for a record the Matches these:

FirstName = Omar
AND
LastName = Swan
AND
Sex = Male


Thanks