DSum refresh?

[redblaze]

hey, how can i refresh a field, containing a DSum expression so that as i change parts of the form which dertermin its value it updates. the thing is it calculates fields in a subform, and i cant get the DSum field to refresh as i change values in the subform. if that makes sence to anybody is there a solution?!

 

[fernin8r]

Try putting a

Me.Refresh or DoCmd.Requery (or Both) on the AfterUpdate property of the control that changes the DSum

 

[Pat Hartman]

The DSum() is not summing the visible rows in the subform, it is summing the rows in the underlying recordset. Therefore, the sum will not change until the current record is saved. Simply leaving the field being summed won't do it.