Sum a tabular subform

[Guest]

Hi all,
I have a sub form that contain an amount field.
I have a Total amount field on a form that the subform is bound to. I'm
trying to add to the Total field each entrance of the amount field but with
no luck. only the LostFocus seems to do the trick but i don't think that the
user will even enter the amount field(the amount field is calculated).
Any suggestions?
Thanks in advance

 

[Guest]

On the after update event of the amount field, you can write the code
Me.Refresh
That way the sum field will update after you enter the new amount and not
after you exit the record

 

[Guest]

Hi Ofer and thanks for the reply.
The problem is that the procedure doesn't trigger the AfterUpdate event at
all.
I've tried to write the sub there but nothing happened.

 

[Guest]

It will trigger the after update event of the field, only when you exit that
field.