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?