I have seen the following problem mentioned here before but have not
as yet seen a fix that works.
When a chart is opened in form view everything is OK. When a chart
based on the same query is opened in a report, sometimes the chart
shows the design view data and not the data from the query. If the
report is closed then reopened, more often than not it will show the
correct data.
This is a serious flaw in Access and makes an otherwise professional
looking database look as though it has a design fault.
Can anyone help? Does anyone know of a fix that works?. Has Microsoft
posted a fix that works anywhere on this. I have seen one that says
to install Service Pack xx but this doesn't work either.
Any help would be appreciated.