A
Atif
I am opening a Select Query in PivotChart view using a ListBox value.
The List Box contains values "NA-E", "NA-W" and "EU-Asia". The problem is
for example if I first clicked on "NA-E" , chart will keep displaying "NA-E"
data even I select "NA-W or EU-Asia" later. I have to close the Chart to see
the other values results.
Any suggestions?
this is the code I am using to open query in PivotChart view:
Private Sub GrpMgrUSD_DblClick(Cancel As Integer)
DoCmd.OpenQuery "GrpMgrUSD", acViewPivotChart
End Sub
The List Box contains values "NA-E", "NA-W" and "EU-Asia". The problem is
for example if I first clicked on "NA-E" , chart will keep displaying "NA-E"
data even I select "NA-W or EU-Asia" later. I have to close the Chart to see
the other values results.
Any suggestions?
this is the code I am using to open query in PivotChart view:
Private Sub GrpMgrUSD_DblClick(Cancel As Integer)
DoCmd.OpenQuery "GrpMgrUSD", acViewPivotChart
End Sub