I have a form that has a previousBalance, subtotal and a total text boxes linked to a table. the previousbalance has to be yesterday's subtotal when I Input a new record, and todays subtotal will be tomorrows previousbalance. Is there a way to do that?? all help will be appreciated. thanks

It's not good practice to store a balance unless it's an audited figure. Use a RunSum function to calculate it.

can you give me an example on how to use the runsum function and where to put it. thanks