Textbox won't update with new values of sub-form !

[Guillaume777]

I have a textbox on my main form that calculates the total of a field on the sub-form. It works well and display the correct ammount on the textbox when I load up the form, but if I do changes the values of the sub-form it doesn't update at all ! I need to close and open the form again to see the changes.

How can I update the textbox so it always reflect the values on the sub-form ?

 

[ansentry]

Have a look at my sample, if you add an item to the subform you will see that it will re calculate the extended price and the total of the form.

Click Here


It is also a good idea to do a search before you post.