Question:
I am developing a s/w with an Access database, using ADO. Now, I want to search a table with multiple columns. As in find method (ADO), it allows only one column to search. How do I search a record with a multiple column search?
Answer:
Use the Recordset’s Filter property. You can use any valid SQL WHERE clause (without the word WHERE), such rs.Filter=”fname=’Mike’ AND lname=’Jones'”. This method filters the recordset to contain only matching records.
To remove the filter, set the filter property to blank or zero.