Disable Remove Filter Option

[CanuckChuck]

Hello,

I have all the necessary security setup for my database. The only problem is once the users have logged in, they can go to the Records Menu and click Remove Filter/Sort and they can view everybody else's records. Is there a way to get rid of this option on the default menu?

Thank you for your comments

[Lysander]

Hello,

I have all the necessary security setup for my database. The only problem is once the users have logged in, they can go to the Records Menu and click Remove Filter/Sort and they can view everybody else's records. Is there a way to get rid of this option on the default menu?

Thank you for your comments

In Access 2003, go into the Startup menu and unclick the four options, Allow Full Menus, Allow Toolbars, Allow Default Shortcuts etc.

This will remove the right mouse click options.
You can then design your own menu, to replace the default menu, and specify that in startup

[CanuckChuck]

Thank you for your reply. I had actually previously done that, but the option still remained on the top default menu bar....
As I read your post I solved my problem while viewing another discussion thread... I found the code to use for the On Open event of the form. Here it is for anyone else who comes across the same problem:

'To disable the Remove Filter/Sort Option on the Records Menu
CommandBars("Records").Controls(4).Enabled = False

Cheers

In Access 2003, go into the Startup menu and unclick the four options, Allow Full Menus, Allow Toolbars, Allow Default Shortcuts etc.

This will remove the right mouse click options.
You can then design your own menu, to replace the default menu, and specify that in startup