Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter in Report Title

Status
Not open for further replies.
wiginprov

wiginprov

Technical User
May 5, 2001
35
US
How do I capture a parameter value in the report title?

Example: I am running a report to filter data for a particular individual. A prompt appears to enter the individual's initials. I want these initials to appear as the report header.

Many thanks.
 
Sort by date Sort by votes
Add a text box to the report header with the Control Source something like:
Code: 
="Report for user: " & [Your prompt]
Make sure that [Your prompt] is spelled exactly as it appears where it is defined.....

HTH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
243
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
274
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
242
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
238
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
254
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top