Calculated Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a calculated control on the form footerof a subform. I want to update this calculated control to the header file. I did try many ways, but still none is working. Looking for help!!
 
First, let me add that generally, you do not want to save calculated amounts for the basic reason that they need to be recalculated whenever the data changes. That having been said..

On one of the properties of the subform, like the On Close, put code similar to the following

[HdrCalcField] = Forms![sfrmCalcAmt]![CalcField

You may have to play with the syntax since I do not know you form/subform setup. If you have difficulty, try using the expression builder to see the syntax and then put it into your code.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

control name literal 1
Page Numbering 2
Summing the value of calculated control on subform to a main form 2
Calculating... 4
Subform calculations 1
Want Sum in Report Header of calculated field in Report Detail ? 1
unbound control calculation help 1
Calculation from a subform 6

Back
Top