Thermometer chart on form

[mtom5]

I am using a one column chart on a form (unbound object) which references a query that sums a field in my table that tracks monetary amounts. As I enter records and go to the next record the chart does not update. It only updates when I close and then open the form. Has anyone had experience using this type of chart on a form and had it update after each record was entered?

Thanks

 

[Mile-O]

Try the following from your form's Current event.

Me.GraphName.Requery

The graph's RowSource, of course, does need to contain paramaters feeding off the current record.

 

[mtom5]

Thanks

Thanks SJ. That tip worked great !!