Link to home
Start Free TrialLog in
Avatar of mindChaos
mindChaos

asked on

Getting the Current Selected Record on an Access PivotChart

Hello,

I started a small Access 2003 project that handles stoked items. I started playing with a pivot chart (for the first time may I say) and got a pretty good idea of how it works. I want the user to click on a data series on the chart and fill some textboxes with the corresponding data. I can loop through the category axis and get the values there may be but that's not what I need.
I need to catch on the SelectionChange event the current selected data series to then "find a way to" take it as reference to get the other values I need to fill in the boxes.

I've used:
obj.SeriesCollection.PivotAxis.Data.CurrentCell.Aggregates(0).Value, which returns always the same value regardless of the selected data series. (there's only one aggregate on the value axis)

and also:
obj.SeriesCollection.PivotAxis.Data.CurrentCell.ColumnMember.Caption that returns always the same value as well.

I appreciate any suggestion on the matter (plus there are points too ;P)

Thank you very much!!
Avatar of puppydogbuddy
puppydogbuddy

This is not the solution, but if you experiment with your code a little bit , it may lead you to the solution.  The link seems to say that the Chart Workspace must be referenced in the Selection List.   It also mentions selecting and clearing the Plot Detail Records checkbox.                       http://office.microsoft.com/en-us/access/HP030882581033.aspx

HTH
Avatar of mindChaos

ASKER

Thanks for the quick reply puppydogbuddy! Very interesting things on the links you provided; but I'm filtering my pivotchart on a subform and works very smooth. I just need to be able to click on a data series and, at least, get an x co-ordinate indicating where the series is so I can go y-wise and get the values I need (+ the x values as well)
ASKER CERTIFIED SOLUTION
Avatar of puppydogbuddy
puppydogbuddy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial