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?
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: