Dsum - running sum?

[bpdavis]

I have a subform that displays the hours worked for the last month, and I have a control that uses the Dsum function to display the total hours worked today. The problem is, it doesnt update itself whenever a record is added. How can i make this a sort of running sum?

I tried doing a doing a requery in the after update event for the subform - but it returns an error message

[This message has been edited by bpdavis (edited 06-28-2001).]

 

[Rich]

In the after update of the last control on your subform you could put refresh, recalc etc, but of course you have to tab out of the control to fire it.

 

[bpdavis]

Ah, thank you so much. I didn't even know the recalc command existed.

[This message has been edited by bpdavis (edited 06-28-2001).]