C ccox Registered User. Local time Yesterday, 23:35 Joined Dec 27, 2005 Messages 32 Oct 14, 2008 #1 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?
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?
khawar AWF VIP Local time Today, 10:35 Joined Oct 28, 2006 Messages 870 Oct 14, 2008 #2 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
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
C ccox Registered User. Local time Yesterday, 23:35 Joined Dec 27, 2005 Messages 32 Oct 24, 2008 #3 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?
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?