ApplyFilter Method

Microsoft Office Web Components Object Model

ApplyFilter Method

       

Filters the record on a data access page based upon the currently selected field. Equivalent in functionality to the Filter by Selection button on the record navigation control.

expression.ApplyFilter

expression   Required. An expression that returns a DataPage object.

Remarks

This method relies upon the current selection on the data access page to determine the field to filter by. Therefore, you must set the focus to the field to sort by, when the procedure containing this method is invoked by a control on the data access page, such as a command button.

Example

This example filters the data access page based upon the currently displayed item in the CategoryID field.

Sub Command0_onclick()

   MSODSC.Datapages(0).FirstSection.HTMLContainer.Children("CategoryID").Focus

   MSODSC.Datapages(0).ApplyFilter

End Sub