Determine lowest selected value among combo group

[John]

I have five combo controls on a form. Each unbound combo offers the
same choices----select a number from 1 to 10. Here's the challenge,
how can I determine what the lowest selected value is among all five
combos?

So, if:
Combo A= 4
Combo B= 8
Combo C=2
Combo D=9
Combo E=3

I need to store value 2 in a variable (VBA). But, how can I do this in
vba? Any help is greatly appreciated!

 

[Allen Browne]

See the MinOfList() function here:
http://allenbrowne.com/func-09.html

 

[John]

See the MinOfList() function here:
   http://allenbrowne.com/func-09.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -

Beautiful. Thank you, Allen!