Refresh chart

[jle0003]

I am working in 2007 MS Access.



What I would like to do is auto-refresh a chart when data on another form is changed.

frmMain contains command buttons for all the available actions and a summary chart of ticket status.
frmTicket contains the field "Status" (this is where the status is changed by the user).

I would like for the frmMain to appear somewhat like a dashboard meaning each time the user changes the Status in frmTicket, have the bar graph auto refresh to reflect the new status in it's count without the user having to close and reopen frmMain.

Can this be done and if so, how? The macro: RunCommand > Refresh did nothing.

Thanks!

[June7]

Never needed to try this but since a chart has a RowSource, just like a combo or list box, I expect that Requery method would work, like:

Forms!formname.chartname.Requery