How do I do Calculations on a Form???

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
 
R

Rick Brandt

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
New computer, how do i move outlook 365 ENTIRELY? 0
Link a text box based on drop down box with four options MS Word 365 0
Calculating an Average 11
Finding the right style field in VBA 0
Using a Parameter Query in a Report? 2
Form showing ID value, not text for field 6
Calculating averages on a form 3

Top