How to know when a Sum Of function has been updated

[EddieN1]

I have a datasheet view with several numeric fields and corresponding SumOfs the same fields. When I view this in datasheet mode and change a numeric value, the SumOf fields takes a short time before they update. I can accept that, however, I need to get access to the SumOf fields as soon as they have be re-calculated, not before. When I try to use the SumOf value in the AfterUpdate event, I find that it hasn't been updated yet and I get the "before updated" value. How can I know when the SumOf fields have been re-calculated or how can I force the re-calc. Thanks, Eddie

[Rawb]

Personally, I don't use Datasheet View so I don't know if you can do this or not, but you can force any linked field to show updated information by using the .Repaint Method.

Public Sub Combo1_AfterUpdate()
  ' Update the value of the "Text3" immediately when anyone changes "Combo1"
  Me!Text3.Repaint
End Sub

If that doesn't work, you could probably use .Requery (although that's typically used for fields that aren't directly Bound to a Table/Query Field).