Filters

[NewfieSarah]

I have a function button set up to filter my data, if I push the F8 button the filter displays and then enter my filter critera and push F9 this then displays my filtered search results. Once I am finnished with my results I would like to clear the filter so it does not appear in the field again. Once i close my form, or program the filter should be clear and then when I re-push f8 there should be nothing on the filter page. Is this possible?? How can I do this? Thanks

 

[supercharge]

See attached -

After the form (frmAccess) loaded, press F8, enter or select criteria, press F9 to apply the filter. Applying a filter will display results and the criteria itself also. Pressing F9 will also remove filters. Therefore, pressing F8 after F9 will enable the filter by form feature but will clear out the criteria.

 

[NewfieSarah]

Thanks alot, this example really works. I have the filter problem solved. Such a weight off my sholders. Thanks again