Expression in a form (1 Viewer)

[paul young]

I am creating a simple database for a small community bank. I created a current account with a subform that includes all transactions (deposits and withdrawals). I wanted to put an expression on the current account showing the balance after each transaction is made. I used the text box, 'balance' to show the balance but it showed up as '#Name?'. The expression used:

=[CurrentAccountTransactions].[Forms]![BalanceAfterTransactions]

It supposed to be simple but where have I gone wrong?? I used the guidance from the Northwinds database, the Orders and SubOrder forms. The expressions are pretty identical. Anyone who provides the light would be much appreciated! The database is attached.

Paul

 

[indesisiv]

Originally quoted by Paul Young

=[CurrentAccountTransactions].[Forms]![TotalDeposits]

This should be

=[CurrentAccountTransactions].[Form]![TotalDeposits]

Try that.

Steve