Calculate based on 2 option boxes

ccox

Registered User.
Local time
Yesterday, 23:35
Joined
Dec 27, 2005
Messages
32
I have 2 option boxes, impact and likelihood, with a numerical value. I would like the calculation of impact * likelihood to be updated in a text box for severity. Is this possible?
 
You should not be storing calculations
Just store value of option boxes in table and calculate the result in query

However if you want it would be a simple multiplication
Code:
YourTextBox = impact * likelihood
Use this code on the after update event of option boxes
 
There doesn't appear to be an After Update on option boxes and putting the code in the priority box isn't working either. any other ideas?
 

Users who are viewing this thread

Back
Top Bottom