Update Field with Calculated Control....

  • Thread starter Thread starter Ray Gibson
  • Start date Start date
R

Ray Gibson

I have a form that amongst other things has a "Payment Calculator Section"
The fields APR and No.OfPayments are bound to the underlying table.

I have 3 Calculated controls that change based upon the above mentioned
bound fields. The calculated controls are TlFinChrg, MonthlyPay, TlPay.

I want to store the "Final" results of these controls in the underlying
table and their fields are setup in the underlying table. I've tried
setting the AFTERUPDATE Source of the calculated controls to:

Me!Database_Field_On_Form = Me!Calc_Control_On_Form - -- But after the
calculated controls change the other fields don't.

The Database_Field_On_Form are hidden.

Can someone please help?

Thanks in advance...

ray
 
It is considered poor design and database inifficiency to
store calculated fields. Do the calculations in the form
or report.

Jim
 
Back
Top