By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

Using button to trigger calculation of a field in a form

P: 14
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.
Jan 29 '15 #1
Share this Question
Share on Google+
3 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
You need to provide us with the calculation that you want to take place.
Jan 29 '15 #2

P: 14
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
Jan 30 '15 #3

Expert Mod 100+
P: 2,321
Expand|Select|Wrap|Line Numbers
  1. Private Sub Button_Blick()
  2.   Me.Field6=FV(I, nper, pmt, pv, 0)
  3. End Sub
Jan 30 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.