ODSOFilters.Add Method (Office)
Adds a new filter to the ODSOFilters collection.
Syntax
expression .Add(Column, Comparison, Conjunction, bstrCompareTo, DeferUpdate)
expression Required. A variable that represents an ODSOFilters object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Column |
Required |
String |
The name of the table in the data source. |
Comparison |
Required |
MsoFilterComparison |
How the data in the table is filtered. |
Conjunction |
Required |
MsoFilterConjunction |
Determines how this filter relates to other filters in the ODSOFilters object. |
bstrCompareTo |
Optional |
String |
If the Comparison argument is something other than msoFilterComparisonIsBlank or msoFilterComparisonIsNotBlank, a string to which the data in the table is compared. |
DeferUpdate |
Optional |
Boolean |
Specifies whether to delay updating the filter. Default is False. |