ODSOFilters.Add Method
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 | Default is False. |