I have several "old apps" that when developed used "Right-click" functions extensively. In most cases, the right-click function involved launching a "Public Function" to carry out the desired task. The mystery for me has always been "where to code the Public Function?". Most of the time, Access only "sees" the Public Function if it's coded in a general module, but I have several instances where the Public Function is coded within a "form's module". (The latter not to be confused with functions referenced within an Event.) Currently, I have a case where Access can ONLY "SEE" the Public Function when the code is within a general module, whereas I'd really like to have it within the form where it is needed.
For those of you that might not have experiences in the early versions of Office, below are examples of how pop-up menus were supported. In the first of the two examples shown, the Function "=DelRes(0)" is coded within the form that makes use of the form. How it is that ACCESS finds that code whereas in some cases it can't is my question?