By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Pass report name to module

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.