sum on form

[amna77]

hi on my form i am tying to get total, like total defects, by doing =Sum(([TBlush])+([TBurn])+([TContanmination])). i does calculate sum, but it does not show changes right away, i tried to put requery macro on after update event of thos three fields, so when ever i enter any number it shoud update my total defects right away, but it does not. it does update when i move back and forth in my records.
anyidea why i am not getting update defects right away? what should i do?
tahnks in advance

 

[tonnic]

Hi,

do you change the values of the three fields on the formular?

If yes, than you only need a little VB-Script .

Private Sub TBlush_KeyUp(KeyCode As Integer, Shift As Integer)

Me.[ControlwithSUM].value=Sum(([TBlush])+([TBurn])+([TContanmination]))

End Sub

and then repeat this for the 2 other fields.

 

[amna77]

thanks for reply, but it is keep giving me error that sub or function not defined, any idea what i am doing wrong. i have the same codes as you said.

thanks

 

[Andrew Fergus]

Hi
the problem you have described is quite normal. Access can't recalculate the total until the record has been saved. I'm no good with VB but one of the VB experts might help with a routine to force the reocrd to be saved after any one of the three fields in question has been updated.
Andrew