ACC: Cannot Completely Remove Form FilterLast reviewed: August 1, 1997Article ID: Q172284 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When you apply a filter or sort to a form and then click Remove Filter/Sort on the Records menu, it appears that the filter or sort has been removed. However, if you check the Filter property and OrderBy property in a Visual Basic for Applications procedure or in the form's property sheet, you see that these properties contain the values that were in effect before you removed the filter or sort.
CAUSEThe Apply Filter/Sort and Remove Filter/Sort commands on the Records menu change only the values of the FilterOn and OrderByOn properties. These commands do not affect the values of the forms's Filter or OrderBy properties. Selecting Remove Filter/Sort on the Records menu simply sets FilterOn and OrderbyOn to False. As a result, the form displays all of the records, because, although the filter or sort is still present, it is no longer in effect.
RESOLUTIONThere are two methods for completely removing a filter or sort from a form.
Method 1Use the form's property sheet to remove the filter or sort. To do so, follow these steps:
Method 2Use a macro or a Visual Basic for Applications procedure to remove a filter or sort. In the following example, the filter and sort are removed during the Current event of the form.
Private Sub Form_Current() If Me.FilterOn = False Then Me.Filter = "" Me.OrderBy = "" End If End SubNote that if you use this event procedure to remove a filter, the only way to activate the filter again is to recreate it. On the Records menu, point to Filter and click the appropriate command to recreate the filter.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information, search the Help Index for "Filter property," "FilterOn property," "OrderBy property," and "OrderByOn property." Keywords : FmsProp kbusage Version : 7.0,97 Platform : WINDOWS Hardware : x86 Issue type : kbprb Solution Type : Info_Provided |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |