Dynamic Report Titles 2

[deweb]

I have a report based on a parameter query that filters records by year.

My question is this, is there a way to incorporate the year information into the report's title?

For instance, if a user types the parameter "2003" into the message box, I would like the report title to read: "All Trainings for 2003"

Thanks.

Denise

 

[SgtJarrow]

the best way to accomplish this is to move away from the parameter query and develop controls to reference...on the form where you click the button to open the report, place a small text box....in the query, where you have the [parameter], put Forms![FormName]![ControlName] and add the same in the report control where you want to include the info....="All Trainings For " & Forms![FormName]![ControlName]

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[deweb]

Thanks. Have a star.

 

[wafabekhti]

You can also create a text box control, delete the text box label and paste this statement into the control source
="All Trainings for " & [queryParameter]

 

[deweb]

Thanks. This works great.

Denise