C
CCS
Hi~
I have a report that displays productivity data for a
department. The report shows a rep on each page with a
corresponding chart - the row source type of the graph is
a query and the data within that query comes from the same
query that outputs the data on the actual report. The
problem is that I (OS 98) get the correct graph to
correspond with the rep that is on the report but the
supervisor that runs the reports on a monthly basis (has
XP on PC but Access 97)--- gets graphs that does not
correspond with the rep on the report.
Some one had previously suggested the following Code:
Dim objChart as Object
Set objChart = Me!NameOfTheChartControl
objChart.Refresh
Set objChart = Nothing
Did not work - Am i missing something or are there any
other suggestions. Thank you in advance.
I have a report that displays productivity data for a
department. The report shows a rep on each page with a
corresponding chart - the row source type of the graph is
a query and the data within that query comes from the same
query that outputs the data on the actual report. The
problem is that I (OS 98) get the correct graph to
correspond with the rep that is on the report but the
supervisor that runs the reports on a monthly basis (has
XP on PC but Access 97)--- gets graphs that does not
correspond with the rep on the report.
Some one had previously suggested the following Code:
Dim objChart as Object
Set objChart = Me!NameOfTheChartControl
objChart.Refresh
Set objChart = Nothing
Did not work - Am i missing something or are there any
other suggestions. Thank you in advance.