Prev: Embed Excel with form
Next: Toggle button vs Command button
From: Tom van Stiphout on 28 May 2010 23:52
On Fri, 28 May 2010 10:17:15 -0400, "Al Campagna"
<newsgroups(a)comcast.net> wrote:

I'm afraid you missed the requirement of selecting multiple countries.

-Tom.
Microsoft Access MVP


>Natalie,
> Check out Option Groups in Access Help.
> It allows you to group those 5 check boxes into a group, where
>only one check box can be selected at a time, and gives each selection a
>different numeric value. For ex. [optCountry].
> The query can then determine that IF optCountry = 1 then it's "USA,"
>or IF optCountry = 4 it's "Canada" etc...
>
> BUT...
> Now that will work... but it's clumsy... in that the query must
>interpret
>(using IFs) 5 numeric values to a textual equivalent. What happens when you
>have 6 countries? 8 countries?
> Each time you'll have to re-"IF" the query for the added numeric values.
>
> I would suggest a combo box instead, (ex. cboCountry) with a Value List
>of
>all the countries as the RowSource. Then the query can take the combo value
>directly in it's
>SQL statement.
> Country = Forms!SomeFormName!cboCountry
> If another country is added... just add it to the combo's Value List,
>and that's it...
>nothing else to do.
First  |  Prev  | 
Pages: 1 2
Prev: Embed Excel with form
Next: Toggle button vs Command button