Searching values in several fields

RicardoFurtado

There are situations when i need to find records with certain values in more than one field.
I'm using ADO and when i want to find a value in just a single field, i use the Recordset.Seek and the Recordset.Find methods, the problem is that i cant use this methods to search throw several fields
Is there any way to perform a search in a recordset, in multiple fields for more than one value?

chamling

: There are situations when i need to find records with certain values in more than one field.
: I'm using ADO and when i want to find a value in just a single field, i use the Recordset.Seek and the Recordset.Find methods, the problem is that i cant use this methods to search throw several fields
: Is there any way to perform a search in a recordset, in multiple fields for more than one value?
:

Hi there.

If you know, and wish, you can use SQL statements to extract records supplying the field values as where criteria.