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

 

[awedge]

Do you have a macro running?

 

[NewfieSarah]

Sorry yes I do have a macro running. With f8 and f9 in there. condition is [Application].[CurrentObjectType] In (2,3) for f9 condition is ToggleFilter and f8 condition is FilterByForm. Hope this helps you a bit more.Thanks

 

[awedge]

Sounds like your missing your code in your macro to clear your filter upon closing your form.

 

[NewfieSarah]

So there is code that you can add to your macro to clear a filter? What would that be?

 

[Remou]

Hi NewfieSarah
What happened to this thread :
Clear Filter Help
thread702-1142655

 

[NewfieSarah]

Thanks for that, but if you read the other thread you will see that it didnt work for me, anymore ideas??