Updating a chart on subform when record in main form changes

Repent

Registered User.
Local time
, 21:24
Joined
Apr 10, 2008
Messages
108
Hello all;

This is probably a dumb question but here goes.....

I have a form called "frmProductionNumbers" with a subform called "frmSubformTabCtlProductivityWasteCharts" that resides on a tab control.

I want to have the chart update it's values based on data in the currently displayed record.

If I make a record change and then step forward to another record and then back again there is no change or update to the chart.

If I go from form mode to design mode and back again the change is seen in the chart.

I have a text field called "LF Produced" that after that value is changed by the user I'd like the subform/chart to refresh to show the changed value.

I tried putting Me.Refresh in the "On Change" event of the LF Produced text box but nothing happened.

What code do I need to use?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom