Prohibit Filter Off

  • Thread starter Thread starter JimS
  • Start date Start date
J

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.
 
"How" depends on "what". What version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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.
 
Hi Jim,

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

Clifford Bass
 
Back
Top