Display a total on a form

[kporters]

I have a form that updates checking account info. I want to display a running total. I have been able to display a total per record but how do I make the display show a running total?

thanks in advance

 

[essnrv]

Use DSum Function in Form_Afterupdate event.Like below example
DSum([Field Name],[Table Name],Criteria(optional))
intCount = DSum("[Physical Count]", "[Physical Count Temp]", "[Batch Number] =" & Me![Batch Number])

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!