Solved acCmdFilterMenu

[ClaraBarton]

I'm using a continuous form with all the columns using the filter Majp and Arnelgp posted https://www.access-programmers.co.uk/forums/threads/custom-filter-accmdfiltermenu.321050/ It's working great. However, I'd like to be able to clear all the filters with a button. The register below is used for various accounts and when I clear the filter I lose the whole form filter and not just the column filters. How would I reset all the columns back to cleared in vba?

 

[theDBguy]

Can you just reassign the original filter?

 

[ClaraBarton]

Well duh! of course I can. Way too late last night. Thank you.

 

[theDBguy]

Well duh! of course I can. Way too late last night. Thank you.

You're welcome. Good luck with your project.