Open Same Report From Many Forms - Nifty Access

The OP HelpNew2Access asked the question "I would like to put in a module and make it public as I have multiple forms that would use this code. In the future if the code need to be altered it would be nice just to do it in one spot instead of on multiple forms. " HERE:- https://www.access-programmers.co.uk/forums/threads/defining-variables.312774/

I was not entirely clear on what the OP wanted. I did several different examples and eventually arrived at this one which I thought was quite a good example of a generic solution. The way I understood the question was that the form had 7 command buttons on it. There could be as many as 100 forms, this would mean adding/maintaining the Code on each of the 100 or so Forms, which obviously needs to be avoid if possible.

Now whether this is the right way to go about it or not, it's not a question that needs answering at the moment, except to say there are better ways of doing it. But sometimes the evolution of your database/code will take you down a one way street which gets narrower and narrower. When you decide to turn around and come out and start again, it's too late!