Filter Property (Professional Edition Only)

See AlsoproFilterSee                 ExampleproFilterX>Low

Applies To

Dynaset object25TLT8, Snapshot objectHBYSUX.

Description

Sets a filterB3B354 for creating a Dynaset or Snapshot.  The Filter property setting is the WHERE clause in an SQL statement29F05E5 (without the word "WHERE").  Not available at design time; read/write at run time.

Syntax

recordset.Filter [ = criteria ]

Remarks

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.

Data Type

String7WSH0XQ