I'm using Access 2003
I have a form with a subform (datasheet)
I created a shorcut menu, lets call it myMenu, with only Sort Asc and Sort Desc in it that I want the user to use in the subform
In that form I selected ShortCut Menu = Yes and and selected the menu I created in the Shortcut Menu bar property
I tested it by opening the datasheet subform only and it works fine
However I noticed that you have to in the main form also select ShortCut Menu = Yes.
Once I do that if the user right clicks on a column in the subform he gets the full entries, not just what I created.
It makes no difference if I select my myMenu in the main form or not, I still get all the entries which is wrong
What needs to be done so the user only sees the myMenu entries I created?