How do I do Calculations on a Form???

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I have three fields on my Form that I want to use
calculations on:
1) Contract Value (text box)
2) Probability (combo box)
3) Expected Value (text box)

I want to be able to enter the Contract Value and upon
changing the Probability field get the calculation for
Expected Value. Contract Value * Probability = Expected
Value

Can I do this? And if it is possible how do I do it.

Thank you very much,
Antonio
 
Antonio said:
I have three fields on my Form that I want to use
calculations on:
1) Contract Value (text box)
2) Probability (combo box)
3) Expected Value (text box)

I want to be able to enter the Contract Value and upon
changing the Probability field get the calculation for
Expected Value. Contract Value * Probability = Expected
Value

Can I do this? And if it is possible how do I do it.
Click to expand...

In the TextBox named [Expected Value] enter the following as a
ControlSource.

=Nz([Contract Value]) * Nz([Probability])
 
Back
Top