Refreshing a chart on a form

[happywitchie]

I have a form that has a chart on it. Also on this form I have a set
of options that the user can click in order to define what data is
represented on the chart.

I have written the SQL code that takes the user-selected options and
feeds them into the query that the chart feeds from.

My problem is that I cannot get the chart to refresh when the user hits
the "Update Chart" button. I have to close the form and then re-open
it in order to see the new chart. I want the user to be able to select
his options and then click "Update" and have the chart change without
having to close the form first.

I have tried having the chart on a subform and doing the following but
that doesn't work.
Forms!frmParentFormContainingSelectOptions!sfrSubFormChartOnly.Requery

If anyone could help, I'd be really grateful.

Thanks.

 

[happywitchie]

Never mind - I have worked this out now... The following makes it work
for me:

Forms!frmMyForm.chtMyChart.Requery