Graphs on forms

[Andi B]

Greetings all,

If I have a chart on a form, which displays a graphical representation of
the data that the form is showing, is it possible to get the chart to
refresh automatically if the user alters data on the form?

I have tried using Form.Repaint, but it doesn't seem to update the graph.

Many thanks in advance of any assistance,

Regards,

Andi

 

[Mark M]

I haven't used charts on forms, but Repaint just redraws the screen. You
might want to try Refresh for the chart object.

 

[Andi B]

I've never seen the Form.Refresh command...

I haven't used charts on forms, but Repaint just redraws the screen. You
might want to try Refresh for the chart object.

 

[Mark M]

I've never seen the Form.Refresh command...

What version of Access are you using? I've got Access 2003 and there's a
Form.Refresh, Form.Repaint and Form.Requery. In any case, I think you want
to refresh the data for the chart object, not the form itself. Try
something like Me.YourChartObjectName.Requery

 

[Andi B]

I need my eyes tested - Form.Refresh works fine... How the hell I never
spotted it in the command list is beyond me... Thanks a lot