Technically, I suppose you could create some kind of function that could take variables and create a line of executable code.

But creating that function would be WAY more advanced and work than just doing it like the video and copy/pasting your isUserInGroup code around. Not to mention, you are still going to need to code all the buttons that you use to call for that function and send it the variables (form names, actions (opening forms, setting properties, etc.)) which is going to be even more then you have to do now.

So yea it's probably possible, but it wouldn't be easier. I would just keep using it how you have been.

Adam, thanks for your response. Sorry I accidentally posted in the wrong place.

There is no "global handler" of this kind of thing so you need to write code for everything everywhere.  You can save time by making the code really short.  E.g.:

Private Sub Form_Open(Cancel As Integer)
    Cancel = Not AU(CurrUserID)
End Sub

The form above won't open if the custom function AU() returns false.  AU() determines if the current user (identified by global variable CurrUserID) is an authorized user or not.  Then you copy this one line of code to every form and report.  Users can't open these forms and reports even on the navigation pane if they are not authorized.

Kevin
Like usual, very elegant solution.