Thank you ever so much.
To clarify the order should be DDR Date as I can add new DDR's next month, etc or half way throiugh the month that will be added to Balance List.
There is a Query against the SubForm (BalanceSub).

My DDR Form adds (copies) the DDR List (that changes per month, etc) to the Balance Sheet. There I want to be able to calculate the outstanding (not paid ticked) outgoings as well as add new adhoc outgoings to the Balance Sheet and have the running sum all the way to the bottom. I would like to create a small table that has the latest balance 9as of date) so I type this in at the top and it uses this as a starting point for the remaining of the balance sheet. So if I have £100 starting balance, then if I had 3 DDRS listed it would look like this:
Starting Balance: £100
RunningSum
DDR 1 - £10 £90
DDR 2 - £10 £80
Adhoc added - £-5.00 = £75
DDR 3 - £90 -£15

I do this as an excel form at the moment but would have liked to create it as a database as I can add other options into this such as Debts, etc etc as a larger storage of my finances.

Hope that makes sense. I appreciate all the help.