report chart not refreshing query

  • Thread starter Thread starter Andre C
  • Start date Start date
A

Andre C

I have a basic larger query which provides details of all home visits
performed. Using a form and associated vba I filter the recults
further based on for example year of visit. This works fine for a
variety of reports linked to this. However I have created a chart
report which just takes one field from this query and displayed the
result.

Trouble is despite what filters I put onthe form I still get a graph
showling all data, not the filtered version.

Any ideas
 
Andre:

This of course could be directly tied to how the SQL is constructed that
serves as the recordsource for the graph and how it references the form.

However, from time to time, you may need to "slow down" the charts rendering
to get all the data updated properly. Stop by our web and in the Code and
Design tips area, there's a tip on Resolving common problems with Graph.
There's code you can add to your report to assure that it fully queries the
data before rendering.
 
However, from time to time, you may need to "slow down" the charts rendering
to get all the data updated properly. Stop by our web and in the Code and
Design tips area, there's a tip on Resolving common problems with Graph.
There's code you can add to your report to assure that it fully queries the
data before rendering.
Click to expand...

Code did not work but nice site anyway. I need to look at how the sql
is fed to the report I think.
 
Back
Top