calculated control in access subform

J

joyce

Hi there. I need some help with a calculated control for a subform. when i
return to the main i get #error or name. I don't understand what i am doing
wrong. I have to have sum of the contract amt.
this is hard to explain.

here are some that i have been using.
=ContractSubform.Form!txtContractAmtSum

=sum(contractAmt)

both of these will not work.
the first one i thought would work but dont know why it wont

please help

jwb
 
A

Allen Browne

Where did you place this control?

Open the subform in design view.
Move the text box into the Form Footer section (not Page Footer.)
If you don't see any Form Footer section at the bottom of your form, its on
the View menu.

Note that the subform will need to be in Continuous View (not Datasheet
view) to see the result.
 
Top