Run-time parameter as field in report

[ldc]

I have a report based on a query with a run-time parameter. Is there anyway
to "capture" the input from that run-time parameter and print it on the
report? For example I put SMITH in the run time parameter and get all record
with Smith in them. I would like to add SMITH to the header (i.e. Reports
for SMITH).

Thanks!
ldc

 

[Jeff Boyce]

One approach is to use a form to capture/gather the parameter(s), have the
query point at the form for the selection criteria, and have the report ALSO
point at the form for the parameter(s) used.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Duane Hookom]

In addition to Jeff's comments, consider reading why parameter prompts are
never a good idea http://www.tek-tips.com/faqs.cfm?fid=6763.