Parameter report Problem

[Wendy]

Hi

I have one report which I want to run for several areas using an area code
as the parameter. This works fine manually. My question is
If I set up a macro to run the report from the switchboard can I hardcode
the parameter so the operator would just press switchboard button which
related to the area code to email the report. At the moment every record
asks for the area code, which will get tedious on live data as there will be
about 100 records a day!

If it can be hardcoded can you show me how please? or I 'm open to
suggestions for a better method.

Thanks

Wendy

 

[Allen Browne]

Couple of options.

If you want to run the report for just the current record in your form, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
That approach assumes you put a command button on the form to print that
record.

Alternatively, you can replace your existing parameter with one that reads
the record in the form. For example, the paramter might be:
[Forms].[Form1].[Text0]