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
 

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

Saving Control Calculated Fields To Tables 2
calculated field in form - to table 2
Storing Calculated field...I know..I know... 8
Values calculated in a Form entered in the Table? 6
Getting an UnBound control value into a Table field?????? 18
Form Calculations 11
Struggling with Calculated Field on Form to Main Form/Table 2
Calculated field not appearing in Table 5

Top