put rst.Filter rst.Filter="LastName = 'Smith' AND FirstName = 'John'"
Sets or gets
String
Criteria string - a string made up of one or more individual clauses concatenated with AND or OR operators.
Integer
value that specifies the group of records to be filtered from a Recordset. It can be one of the FilterGroupEnum values.
Description
Sets or gets the Filter property of the wrapped ADODB.Recordset object. Use the Filter property to selectively screen out records in a Recordset object. The filtered Recordset becomes the current cursor.
