Code on a form will not work?

[winston01]

On a form, I have a subform which looks at a query and shows the following field:

Withdrawalamount
depositamount

In the footer I created three text boxes and used the following codes to get total withdrawals, total depostis and balances:

=Forms!Transactions![Transactions Subform].Form![Total Withdrawals]

=Forms!Transactions![Transactions Subform].Form![Total Deposits]

=nz([Total Deposits])-nz([Total Withdrawals])

It will not work, yet it works on a form that I copied form the sample ledger database in access help. The only difference I can tell is that my subform looks at a query and the one I copied from them looks at a table. What am I doing wrong? Using the codes above, on the form that is working correctly, how does access know what field to look at?

Thank you!

 

[Eupher]

Hi, winston01,

Is the footer in the subform or main form? As an aside, here's a good link for referencing form/subform controls and properties:

http://www.mvps.org/access/forms/frm0031.htm

HTH,

Ken S.

 

[winston01]

Thank you, the link was a great help. I was missing a control in the footer of the subform that calculated the fields correctly.

I appreciate your help.