[Unsolved] :( MS Access Pivot Table Selection
Hi,
I need to find out what column was clicked along with the selection value from a pivot form.
So far I have been able to find
Me.PivotTable.Selection(0).Value
Which returns the value of the clicked item, but how do I find out what column is it in?
Thanks in advance... Really appreciate your help.
MS Access PivotTable references are almost non existent... actually havn't see one VBA code for it.
EDIT: I won't be at work over the weekend. I hope I get a reply by then.
Hi,
I need to find out what column was clicked along with the selection value from a pivot form.
So far I have been able to find
Me.PivotTable.Selection(0).Value
Which returns the value of the clicked item, but how do I find out what column is it in?

Thanks in advance... Really appreciate your help.
MS Access PivotTable references are almost non existent... actually havn't see one VBA code for it.
EDIT: I won't be at work over the weekend. I hope I get a reply by then.
Last edited: