Refresh chart data automatically

[rscott1989]

I have a number of charts that correspond to form fields. Once the fields are filled out and the form is saved I want the data automatically to update in the chart. I tried inserting a button to allow the user to manually do it, but it says that it is unavailable. The charts update when i click refresh, however I dont want the user to have to do this.

Any ideas?

Thanks!!!

 

[MLUCKHAM]

The chart object has a requery method. You need to call this method to get the chart to refresh. I have done it previously on the onChange event of a drop down box which listed different date options (e.g. 1 week, 2 weeks, 4 weeks, 3 months). So that when the user selects a different date range, the sql statement on the chart is modified and then I call the requery method. Hey presto, the chart as updated!