Refreshing chart after changing query SQL RRS feed

  • Question

  • I have a chart on a form which gets its data from a query and charts moisture content over time. I would like to be able to select a different parameter to display on the same chart by adding option buttons to the form. Once a different option button is selected the chart needs to be updated with the new data.

    I've played around with changing the QueryDefs.SQL with no luck so far in being able to update the chart.

    Any suggestions would be greatly appreciated. 

    Thursday, October 25, 2018 8:42 PM

All replies

  • Hi,

    Is this one of those modern charts in Access 2016 or earlier?

    Sunday, October 28, 2018 3:12 PM
  • You may need to do a Me.YourChartName.Refresh or Me.Recalc after you change the charts record source.
     You should also make sure the charts Update Options property is set to Automatic.
    Sunday, October 28, 2018 3:56 PM