Update Field with Calculated Control....

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
 
J

Jim/Chris

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

Jim
 
Top