calculated control in access subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joyce - 24 Mar 2007 03:05 GMT

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

Reply to this Message

Allen Browne - 24 Mar 2007 03:11 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 13 lines]
>
> jwb

Reply to this Message