
Originally Posted by
dscottf
I have a form containing many records that I want to filter. I created a macro to use the "RunMenuCommand" with FilterByForm as the argument. It works great, but I have to right click on the form to gain access to the Apply filter command. I tried creating another macro with command button to use the "RunMenuCommand" with the Apply Filter argument. The problem is this button is grayed out when the Filter By Form is active and I'm unable to access it. Is there a way to create this?