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!

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.

"John" <(E-Mail Removed)> wrote in message
news:7fbf49b3-61b0-44af-84f2-(E-Mail Removed)...
>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!

On Nov 9, 2:12*am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
> 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.
>
> "John" <soundnee...@gmail.com> wrote in message
>
> news:7fbf49b3-61b0-44af-84f2-(E-Mail Removed)...
>
>
>
> >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!- Hide quoted text -
>
> - Show quoted text -

Beautiful. Thank you, Allen!