requery alternative?

[Rubius]

what I have is a form with 2 subforms(both datasheet view). now, as I edit the data in subform1, subform2 is a display of the running total of the column of data I am updating in subform1. Right now I have Me!Requery set to Ontimer every 5 seconds. Obviously, running code every 5 seconds to update a query is not very efficient, and it makes the hour glass come up every 5 seconds. This is distracting to my employee's. Is there a way to update the running total without using Me!Requery?
thanks in advance!

 

[Carol]

Is your total the only field on your 2nd subform? Why not just have a total field that automatically calculates on the 1st subform, that way you don't need a requery method.