ADO - Find A Specific Record

[omarswan]

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

[Clunietp]

You can't search on multiple criteria with an ADO recordset.

You'll have to issue a new SQL statement to the database, or use your own validation logic (find, test other fields if they match, if not, find again, etc...)

[Clunietp]

Thanks Testicle!

Use the Filter method