Refresh calculated field after update or on change

[james_IT]

Hey

I have a form with two calculated fields (based on other fields in the form). When changing these other fields the calculated fields do not update - only when i save, exit and reopen the form to they change. What code do i need and should it be after update on or on change?? Is there a way to have a running calculation during the change (i.e. refreshed with each keystroke)?

Thanks in advance

 

[boblarson]

In the after update event of each of the controls you might be updating put:

Me.Recalc

 

[james_IT]

perfect! THANKS