Running balance in a form

[Ray67]

Hello



I have a main form which has different command buttons. From the main form user can go to run a report or enter new data. I have a table which has to fields, amount deposit and amount withdrawal. I would like to put a text box in main form which will show a running balance by subtracting amount deposit and amount withdrawal. Can this be done???


Thank you,

[alansidman]

Here is what I use in a form for a checkbook. Put an unbound text box in the footer of your form.

=DSum("Deposits","tblTransactions")-DSum("Withdrawals","tblTransactions")

Deposits and Withdrawals are field names in the table tblTransactions.
Alan

[Ray67]

Alan

I get this error: #Error


Thank you

[alansidman]

First, are the items in your formula surrounded by quotes? Are you deposits and withdrawals in your table formatted as numbers and not text? Did you put the unbound text box in the form footer?

Alan

[Ray67]

I have the table formatted as currency. I didn't have the text box in the form footer. So now i put it in the form footer but when i open the form in form view i don't see the text box.

Thank you

[alansidman]

Make sure that your footer is expanded enough to see it.