Refreshing a total on a form

[C Tate]

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?

 

[Jeanette Cunningham]

Hi,
check out recalc in vba help.


Jeanette Cunningham