Check boxes to run queries




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.



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.

Microsoft Access MVP

Al Campagna

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...

Now that will work... but it's clumsy... in that the query must
(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
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.
Al Campagna
Microsoft Access MVP 2007-2009

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


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?


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.



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.

Microsoft Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question