Displaying Menus in Forms

[Rocinante]

I have written a DB for work that collects information on a range of events (eg safety incidents, improvement suggestions, etc) and reports on them. I am now trying to improve the security & integrity of the data by restricting user access to menus.

I can use the start up options to turn off menus, etc but want to allow users to use the default right click menu in forms to sort & filter the forms. But I don;t want users to have access to the other default menus (eg the one containg form deisgn). Is there a way to just select this particular menu to pop up on a right click?

Because I have not been able to find an answer to this I tried designing my own toolbar containig the sort & filter commands I needed. I created a custom tool bar using the menu/customisze options and called it "tbarSortFilt".

As soon as I place it in the menu bar it goes "dim" and I cannot select the options. When I over ride the start up options ("shift" key) and then right click in teh form both the default menu come up (as expected) and the "tbarSortFilt" menu lights up -- but is not active.

I have also tried

DoCmd.ShowToolbar "tbarSortFilt", acToolbarYes

to no avail.


Clearly there is something pretty basic I am not doing. How can I use the strat up options to turn off toolbars and then show AND activate my customized toolbar?


Regards Stephen

 

[Smart]

If you design the form that is to use the new menu got the form properties then choose the others tab and then in the menu bar option type the menu name

 

[Rocinante]

Thank you for your reply. I added "tbarSortFilt" [the menu name] and it still did not show. It would not let me add it to the menu bar property as it said it was the wrong type.

I can turn off all the menus & tool bars which is what I want to do. I can solve my problem if I can select one of the right click default menu options. How do I do that? I cannot find ant refernces to teh naming of thses any where.

Again thank you for your help.

Stephen