Is there a way to put a button on a form for Apply/Remove Filter? I want users (who are not at all Access-savvy) to be able to Filter By Form without having to go up to the toolbar. I figured out a way to make a command button for Filter By Form, but the problem is that once you press this button and enter criteria, you still have to go up to the toolbar and click on Apply Filter. I tried, with my very limited vba skills, to create a command button for Apply Filter on the form itself, but when you press the Filter By Form button I created, which you have to do first so you can enter search criteria, my other command buttons get grayed out. Will my database users just have to learn how to go up to the toolbar to Apply or Remove their filters?
Thanks
Geoff"
Thanks
Geoff"