Running total on main form with table as source object of subform
I would like to be able to have a running sum on a main form from a sub form that is based on a table source object. This is an access 2003 database. I am currently able to provide them the total after they have saved the records. I have tried both Dsum and Dlookup to get this to work but it fails.