Check boxes to run queries

[Natalie]

Hi,

I want to use check boxes to choose criteria. I was to return a table for
the following data:

Invoice number, Customer number country, part number, qty, value etc.

There are 5 countries, I want to have a check box for each so we can choose
which ones to include, and then click GO.

How do I do this? I am new to this.

Thanks

Natalie

 

[Tom van Stiphout]

On Fri, 28 May 2010 06:25:01 -0700, Natalie

I'm not sure I understand. Typically an invoice is for a customer, and
that customer has a billing address in some country. Why would you
want to select countries?
Maybe you only want to include invoice lineitems for work performed in
certain countries?

More info, please.

-Tom.
Microsoft Access MVP

 

[Al Campagna]

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.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Natalie]

Thanks for your reply.

This is because we are looking at the international sales for the company on
certain products, so I i want the product specialists to be able to choose
what data they include from the table.

Does this make sense?

 

[Natalie]

Sorry, I'm not sure I understand. I want them to be able to select multiple
countries, all or just one.
Not sure how to do the combo box.

Thanks

Natalie

 

[Tom van Stiphout]

On Fri, 28 May 2010 10:17:15 -0400, "Al Campagna"

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

-Tom.
Microsoft Access MVP