copying a calculated value to a report

R

robertm600635

I've messed with this for a while and can't get it to work. I have a textbox
that is multiplied by either 1 or 12 depending on a selection from a
combobox, and that value is displayed in another textbox. that works fine
with the expression:
=Val(Nz([incVAIncome],0))*[cmbMonthlyAnnual1]
in the Control Source property of the second textbox. What I need now is for
that calculated value to be copied onto a report. Any suggetions?
 
A

Al Campagna

Robert,
If the form is still open at report time, you can directly refer to the calculated
value...
= Forms!YourFormName!YourCalcFieldName
Or, create a calculated column in your query...
(assuming [incVAIncome] and [cmbMonthlyAnnual1] are bound controls)
CalcAmt : Val(Nz([incVAIncome],0))*[cmbMonthlyAnnual1]
 
Top