FilterColumn Property FilterCriterion Property FilterValue Property SortColumn Property SortDirection Property SubmitChanges Method DataControl Object METHOD:  DataControl::Reset datacontrolobject. Reset BooleanValue The Reset method is called to execute either a filter or a sort on a client-side Recordset object. All pending changes to the Recordset must first be saved before calling Reset or the call will fail. You can create a filter string using the FilterColumn, FilterCriterion, and the FilterValue properties. You can specify the column to be sorted and whether the sort order is be ascending or descending by using the SortColumn and SortDirection properties. There is one optional parameter. The optional BooleanValue parameter is a Boolean value of either True or False. The default is True which specifies that the filter is applied to the current data (which may have already undergone multiple filtering). A value of False specifies that the filter is applied to the original (unfiltered) data. Code (VBScript): objDataControl.FilterColumn = strFilCol objDataControl.FilterCriterion = strFilCrit objDataControl.FilterValue = strFilVal objDataControl.Reset Or objDataControl.SortColumn = strSortCol objDataControl.SortDirection = False objDataControl.Reset Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information