Filter Property (Professional Edition Only)
See Also Example
Dynaset object, Snapshot object
Sets a filter The Filter property setting is the WHERE clause in an SQL statement (without the word "WHERE"). Not available at design time; read/write at run time.
recordset.Filter [ = criteria ]
You can use the Filter property to select records or to refine the selection of records in a Dynaset or Snapshot. The Filter property affects only recordsets subsequently created from recordset with CreateDynaset or CreateSnapshot.
You can create a Dynaset or Snapshot, set its Filter property, and then create a new Dynaset or Snapshot. If you create a Dynaset or Snapshot using an SQL statement, there is no need to set this property. The Filter property of the new recordset is empty.