Hi,
check out recalc in vba help.


Jeanette Cunningham


"C Tate" wrote in message
...
I have a main form with a couple of linked subforms on it. Also on this
form
is a textbox containing a dsum function which adds up some totals relating
to
the two subforms. The dsum function actually refers to a separate query in
the database. When I enter new data into the subforms the new total isn't
instantly reflected in the dsum function. I have to move to another record
then go back before the new total updates. Is there a way to change this
so
the new total is updated instantly?