Dynamic Report Caption

[Crypto]

Hey, I have a report that when opened, asks the user to enter a parameter.

Everything is okay except, I want this parameter to also be the header caption for the report. How can i accomplish this?

Thanks in advance!

[ajetrumpet]

does the param come from a query? if so, I don't believe you can use that as a caption too. But, you can make a form that looks like a popup box, throw the input from there to a var and then use that var to change the title of the report before it's opened via a line of code.

reports("report name").caption = "whatever"

[Crypto]

Er, Yes is does come from a query. Fair enough, I will try to do it via form and ask if I need help from there. Thanks!

[Rick West]

Or you can add a txt box in the header of the report and add a control source - something like this:

="Between" & " " & [Enter Start Date] & " " & "Through" & " " & [Enter End Date]

Only problem is the underlying query asks for start/stop dates and then so does the report. but it works.