[need help] selecting maximum value from different fields

[shuto13]

hi everybody,


as the title goes, I need some help here...

I am making a form that looks like this (it's just the rough draft, trying to figure the works first)



what it does, the user picks values from the combo boxes occ1, detect1, sever_eco, sever_hs, sever_envi.
the textbox below sever_eco combobox is a calculated field that is the multiplication of occ1*detect1*sever_eco. and so on for sever_hs and sever_envi.

the problem:
the text box in the blue square
the idea is that this text box picks the maximum value from the text boxes in the red box (i.e. the calculated fields)
is it possible to do so?

I've tried using Maximum([sever_eco],[sever_hs,[sever_envi]) but returned the error #Name?

thanks before

[pbaldy]

There is no such built-in function. You should be able to use this:

http://support.microsoft.com/default...b;en-us;209857

[shuto13]

thanks for the reply

I'll try the coding and compiling and hope that it works also for my case...

I will report back as soon as I get a result...

thanks again

--------
update:
works like a charm...! thankyou very much!

[pbaldy]

Happy to help!