How to refresh aggregate SUM function

[hm1sal]

I have a rather simple database application. Using an ado connection to an access database. I have a form with a text field that get its data from a dataenvironment/command/aggregate SUM that simply totals the value of one column in the database and displays that number in the field.

Works well but the SUM does not get updated if I add a new record until I exit the application and launch again. How and where would I call a refresh/requerry of the aggregate SUM function so when I create a new record the displayed total is correct? Any help would be appreciated.

Thanks

J Salvin

 

[jel]

Just close and re-open the recordset?

 

[hm1sal]

Thanks for the reply Jel, now, can you point me in the direction of how and where to accomplish this. The form has a ado connection to the database (datprimaryrs) I cannot figure out how or where to close and reopen the recordset. Help appreciated.

jsalvin