create A function that refrences forms

[sdel_nevo]

Hi Guys

Thanks very much for your help, after thinking about this at the Pub, I realised that I did not need to restrict the right click menu by user access, so have just restricted for all
admins can still get to the design view at startup however

the code I used was this

'---------------------------------------------------------------------------------------
' Method : RightClickMenu
' Author : me
' Date   : 08/06/2017
' Purpose: Stop Right Click menu On Forms
'---------------------------------------------------------------------------------------
Public Function RightClickMenu(frm As Form)
        
   On Error GoTo RightClickMenu_Error
   frm.ShortcutMenu = False
   On Error GoTo 0
   Exit Function
RightClickMenu_Error:
    MsgBox "Error Has Been Found " & Err.Number & " (" & Err.Description & ") In Procedure (RightClickMenu) Of (Function ModUtilities)"
End Function

and called using this

'hide short cut menu based
   Call RightClickMenu(Me)

thanks very much to you both



Steve

[pbaldy]

So why not skip the code and set it in design view?

[sdel_nevo]

Hi Mate

because I'm silly, and never even thought of that lol,

well that's one way to over engineer a solution

Steve