How to filter data when right click is disabled?

[supernova]

I have disabled "Allow Default Shortcut Menu" for security purposes but now I can't right click on my form and filter data. Any idea? Data type is date/time if this helps.

Thanks in advance

 

[arnelgp]

on the sample db "Allow Default Shortcut Menu" is enabled so you can view the macros used.
edit the form table1. look at the property of DateTime control.
goto property->others Shortcut menu.
it uses macro1, which in turns call MenuItem macro to show the filter.

if you are ready disable the default shortcut menu and run table1 form again.

 

[supernova]

on the sample db "Allow Default Shortcut Menu" is enabled so you can view the macros used.
edit the form table1. look at the property of DateTime control.
goto property->others Shortcut menu.
it uses macro1, which in turns call MenuItem macro to show the filter.

if you are ready disable the default shortcut menu and run table1 form again.

Thanks. This worked great but can you explain why we need a submacro and can't do it in a single macro?

 

[arnelgp]

2 macros because the first macro (macro1) add our 2nd macro (MenuItem) for its menu.
you can't directly use MenuItem macro as Shortcut Menu bar for the control.