Prohibit Filter Off

[JimS]

How can I prevent my form from being "unfiltered". I want the form to show
only the filter I have set for it programmatically. I don't want a curious
user to click on the "filtered" box at the bottom of the form to clear the
filter.

 

[Jeff Boyce]

"How" depends on "what". What version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JimS]

Sorry, A2007. I was able to hide the little box at the bottom of the form
that indicated filtering. I'll need to disable the ribbon command.

 

[Clifford Bass]

Hi Jim,

I have not used them, but have you tested out the On Filter and On
Apply Filter events?

Clifford Bass