Pass report name to module

[CQ]

I have a module that appends a table with a report name when that
report is run. The problem that I am having is that I don't know how
to get and pass the report name to a variable. Right now, I have it
hard-coded and that is no way to run a railroad!!

What I want is thus: When the user hits a report I want that report
name (or command button, or whatever I can use) to be passed to the
module so that I can use the module to append my table.

[Larry Linson]

Eh? Could you clarify "when the user 'hits' a report?"

It should be easy enough to put code in the Open or Close event of each
report that is something like:

YourSubsName Me.Name

where you substitute your sub procedure's name for "YourSubsName". Is that
what you were looking for? It will call the Sub, passing the name of the
Report as an argument, whenever the Report is executed.

Larry Linson
Microsoft Access MVP
"CQ" <co*****@yahoo.com> wrote in message
news:d1**************************@posting.google.c om...

I have a module that appends a table with a report name when that
report is run. The problem that I am having is that I don't know how
to get and pass the report name to a variable. Right now, I have it
hard-coded and that is no way to run a railroad!!

What I want is thus: When the user hits a report I want that report
name (or command button, or whatever I can use) to be passed to the
module so that I can use the module to append my table.