Chart title from Query parameter

[Fred's]

I have created a chart which is run from a query. When the chart is
opened, the user is prompted to enter a parameter i.e. [Which Merch
Type] - how can i store the value that the user enters and use it in
the title of my chart.
For example,
If the user puts in "Footwear", and presses enter, i would like
somehow
for the chart title to read - "Footwear"

Thank you,
Fred's

 

[fredg]

I have created a chart which is run from a query. When the chart is
opened, the user is prompted to enter a parameter i.e. [Which Merch
Type] - how can i store the value that the user enters and use it in
the title of my chart.
For example,
If the user puts in "Footwear", and presses enter, i would like
somehow
for the chart title to read - "Footwear"

Thank you,
Fred's

The chart is in a report?
Code the Report section's Format event that the chart is placed in:

Me!OLEUnbound0.ChartTitle.Text = "Sales for " & [Which Merch
Type]
Me!OLEUnbound0.Refresh

Change [Which Merch Type] to exactly whatever the prompt is in the
query.

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

 

[Fred's]

I have created a chart which is run from a query. When the chart is
opened, the user is prompted to enter a parameter i.e. [Which Merch
Type] - how can i store the value that the user enters and use it in
the title of my chart.
For example,
If the user puts in "Footwear", and presses enter, i would like
somehow
for the chart title to read - "Footwear"

Thank you,
Fred's

The chart is in a report?
Code the Report section's Format event that the chart is placed in:

Me!OLEUnbound0.ChartTitle.Text = "Sales for " & [Which Merch
 Type]
Me!OLEUnbound0.Refresh

Change [Which Merch Type] to exactly whatever the prompt is in the
query.

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

- - - - -

Hello,
Thank you very much. However, I still have a question, here is it:
The prompt can be Footwear or Handbags or Accessories or none of
these, so how should set the [Which Merch Type] in that case?

Your support is very appreciated.
Fred's