Updating Question

[north-bc]

I have a main form with 6 subforms on it all in a Tab control. The information from the first 5 subforms are tallied (via text boxes) on the 6th to give a total for all the forms. The problem is when I go back to one of the earlier subforms and change a value of a field and then move to the last subform the total value (text box) has not changed. The only way I can have the changes take effect is by moving to a new record on the main form and then back to the record where the changes took place.

I have tried using different things and nothing seems to work.

Any ideas would be greatly appreciated.

Thanks,
Todd

 

[jeremie_ingram]

Have you tried to do a refresh or recalculation on the ON CHANGE or ON EXIT properties of the text boxesa? If someone were to make a change, then the code would be triggered to refresh.

 

[north-bc]

Thanks

Thanks,

I used this in the Activate properties of the subform
Me.Controls!Total_Pts.Refresh
and it seems to be working fine now.