I have a split form with a sum of totals in the form footer. The total shows as long as the fields are filled have data and as long the cursor is not moved in to the next bank field of a new record. How can I get the total to always show and calculate properly?