Dynamically update a graph on a form

[aymanmb]

I managed to insert a graph on my form based on a count query of my orders table. So it display now the number of pending orders (EndDate field is null)

How can I make it dynamic i.e. when an Order is no more pending, the graph will automatically be updated.

I guess the query has to be refreshed but do not know how to programtically do that when the record change (order not pending i.e. EndDate field is not null)

 

[Moniker]

In the record's AfterUpdate event, do a Requery and Refresh on the graph object.