forms to tables

[Andrew.Champion]

I have built a form from an existing table. As I enter information on the form it is also inserted in the table. I have two fields in which i had to enter a formula from input of the other fields in the form. What do I need to do in order for the results of the formula to be entered back into the table. I am using Access 2010. Thank you in advance for any help with this issue.

 

[Galaxiom]

What you propose sounds like storing derived values and should generally be avoided. The calculated values are recalculated whenever they are required on reports or forms.

Read about Normalization to further understand this concept.

When calculations do need to be stored they are either entered into a bound control using VBA on the AfterUpdate Event of other controls or saved to the the form's recordset using VBA in the BeforeUpdate Event of the form.

 

[Andrew.Champion]

I have figured out how to complete this issue. Thank you to all for your help