D
dfkwtx
Guest
I'm trying to have a form which displays a chart of layered sales information. When you open the form it would have a chart with one bar for total sales. When you double click the bar, the chart would then update to show two bars for US and European sales. When you double clicked on the European bar, it would then update to show sales by country, and so on.
There would not just be one drill down path. I would have a combo box which listed several alternate paths from which to start and end. I figure I could use a select case on the combo box value to signify which path I was on. Additional code would reset the Record Source to a new SQL Query for the chart.
My problem is that I do not know how to return some kind of value when I double click on a chart bar that would let me know which bar I selected, and therefore, which path along the tree to take. I was thinking that I could store the values in variables which the SQL query would then use as criteria for the next level to be displayed.
It wasn't in Access, but I saw a program several years ago which could do this.
Any suggestions would be appreciated.
Thanks
There would not just be one drill down path. I would have a combo box which listed several alternate paths from which to start and end. I figure I could use a select case on the combo box value to signify which path I was on. Additional code would reset the Record Source to a new SQL Query for the chart.
My problem is that I do not know how to return some kind of value when I double click on a chart bar that would let me know which bar I selected, and therefore, which path along the tree to take. I was thinking that I could store the values in variables which the SQL query would then use as criteria for the next level to be displayed.
It wasn't in Access, but I saw a program several years ago which could do this.
Any suggestions would be appreciated.
Thanks
