use updated value of form total in vb

I have a form with a total in the footer (=Sum(field)) & would like to use the updated value in an event before leaving the form, but in the Unload Event of the form, the total has not yet been updated, & by the Deactivate Event of the form, it is gone....

Any advise would be much appreciated!

Thanks!

What exactly are you wanting to do with the Sum field on your form? Unless it is bound to your table the variable will be destroyed when the form closes. Are you wanting to take this value and use it some place else in your application?

lwells