Posting Values to a field...

[SandTiger]

I created a form with one field that adds the sum of other fields and display the result. Now I need that value to also be posted into the field in the main table. How is this done?

 

[Ken Snell]

Are you sure you need to store the sum into a table? It's not a normal thing
to save calculated fields.

But assuming that you do need this, create another control on the form; name
it the same as the field that is to get the value. Bind the control to that
field (control source). Then, in the BeforeUpdate event of the form, use
this code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.NewFieldName.Value = Me.SumField.Value
End Sub

--
Ken Snell
<MS ACCESS MVP>

I created a form with one field that adds the sum of other fields and

display the result. Now I need that value to also be posted into the field
in the main table. How is this done?