Hello,
I am trying to make a custom shortcut menu for my reports. I have them set for a viewer only, with no menus or ribbons. I want to disable the shortcut box with design view, but my client really wants the ability to right click on any record on the report and be able to use the filter option that appear in the drop down.
I have searched and searched and haven't been able to find a way to keep that function accessible, and disabling the option to enter design view and make any changes.
I've come to the conclusion that I am going to have to use a macro to build my own shortcut menu, but I'm not quite sure where to go with it.
What commands should I use to allow those filtering options?
Any help would be great and much appreciated!!
Thanks!