Record.SetFilter(Any, Text [, Any,...]) Method
Version: Available or changed with runtime version 1.0.
Assigns a filter to a field that you specify.
Syntax
Record.SetFilter(Field: Any, String: Text [, Value: Any,...])
Parameters
Record
Type: Record
An instance of the Record data type.
Field
Type: Any
The field that you want to filter.
String
Type: Text
The filter expression. A valid expression consists of alphanumeric characters and one or more of the following operators: <, >, \, &, |, and =. You can use replacement fields (%1, %2, and so on) to insert values at run-time.
[Optional] Value
Type: Any
Replacement values to insert in replacement fields in the filter expression. The data type of Value must match the data type of Field.
Remarks
SetFilter does not filter for empty values. For example, if you set MyRecord.SetFilter(MyTextField, ''); no filter is applied.
This method is like the SetFilter Method (FieldRef) method. For more information, see FieldRef.SetFilter(String [, Any,...]) Method.
The filter set by the SetFilter Method (Record) or the SetRange Method (Record) apply to the currently selected filter group. For more information see FilterGroup Method (Record).