Chart title

[ladybug via AccessMonster.com]

I have a chart on a report. When the report is opened a query runs that
prompts the user for criteria. The user has to type in a program name. The
report data will reflect only that of this program. I want there to be a
text field on the chart (preferrably as the chart title) that automatically
inputs the program name as specified by the user. How do I do this?

 

[fredg]

I have a chart on a report. When the report is opened a query runs that
prompts the user for criteria. The user has to type in a program name. The
report data will reflect only that of this program. I want there to be a
text field on the chart (preferrably as the chart title) that automatically
inputs the program name as specified by the user. How do I do this?

\
If a form is used to enter the parameter...
Code the Report section's Format event that the chart is placed in:

Me!OLEUnbound0.ChartTitle.Text = "The program name is " &
Forms!FormName!ProgramControl
Me!OleUnbound0.Refresh

The form must be open when the report is run.

If just a query parameter prompt is used:

Me!OLEUnbound0.ChartTitle.Text = "The program name is " & [Enter
Program Name]
Me!OLEUnbound0.Refresh

The text within the brackets must be identical to the bracketed
criteria text in the query.

Change OLEUnbound0 to whatever the control name is of your chart
control.