Using button to trigger calculation of a field in a form

[Hishow]

Good day to you all.
Please I have a form with 6 unbound fields (Field 1-6). Field6 depends on the input of Field1-5. I do not want Field6 to update automatically while inputting data into field1-5. I have a button called "Calculate" . I want field6 to update only on the click of this button "Calculate" . Any Vba to use please.

Thank you in advance.

[Seth Schrock]

You need to provide us with the calculation that you want to take place.

[Hishow]

All the calculations have been done using expression. All fields are unbound. Field6 has calculation for FV(I, nper, pmt, pv, 0). Once I insert figure into field1, Field6 automatically recognizes the figure which I don't WANT. I will want a button to update Field6 instead of showing automatically.

Thank you in advance

[TheSmileyCoder]

Private Sub Button_Blick()
  Me.Field6=FV(I, nper, pmt, pv, 0)
End Sub