robjones23
Registered User.
- Local time
- Today, 20:08
- Joined
- Dec 16, 2004
- Messages
- 66
Hello,
I'm trying to have a dynamic title on a pivot chart based on what's been selected in a combo box.
what happens is:
User click item in combo box
Clicks "Get chart" button
Button runs a query and displays chart based on this query
All the above runs fine and the chart is produced. However I would like the title of the chart to change depending on what's been selected in the combo box. I read on msdn that there's a "ChTitle" variable somewhere but I don't know where - I went to the SQL view and put the below is hoping it would work but it didn't (Surprise lol!)
ChTitle=[Forms]![Category Minigraphs]![Combo16]
Any ideas?
Cheers,
Rob.
I'm trying to have a dynamic title on a pivot chart based on what's been selected in a combo box.
what happens is:
User click item in combo box
Clicks "Get chart" button
Button runs a query and displays chart based on this query
All the above runs fine and the chart is produced. However I would like the title of the chart to change depending on what's been selected in the combo box. I read on msdn that there's a "ChTitle" variable somewhere but I don't know where - I went to the SQL view and put the below is hoping it would work but it didn't (Surprise lol!)
ChTitle=[Forms]![Category Minigraphs]![Combo16]
Any ideas?
Cheers,
Rob.
