Sum a tabular subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top