How can I select multiple answers for a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database in access and I have several criteria in which more
than one answer from the drop down box could apply. I would like to make it
possible for more than one option to be selected. Is there an easy way to do
this, or will I just have to create multiple combo boxes?
Thanks.
 
As I am sure you have discovered, a Combo Box allows only one selection from
the list. The alternative would be to use a List Box control with either
Simple or Extended Multi select. If you have not used a List Box control
before, there is a bit of a learning curve. I would suggest you go into VBA
Help and read up on the ItemsSelected property. It is probably the most
importand property to understand for effective use of a List Box. It is a
collection of all the items in the list that have been selected.
 
I am creating a database in access and I have several criteria in which more
than one answer from the drop down box could apply. I would like to make it
possible for more than one option to be selected. Is there an easy way to do
this, or will I just have to create multiple combo boxes?
Thanks.
Click to expand...

Are these search criteria? or are you trying to store multiple values
in one "combo box" field (you can't!)? If they are search criteria, do
you want to return records where *all* of the criteria are True, or
*any* of them is true? More info please!

John W. Vinson[MVP]
 
This question is very good for me because I am facing the same problem.
I want to return records where *all* of the criteria are True. For example,
I have three choices: Male, Female or both, but the user must select only one
choice.
Please Mr.Vinson could you answer this for me


"John Vinson" كتب:
 
Hi YoungPioneer,

If you want to be able to select more than one choice in a combo, you
can't... you will need to use a multi-select listbox.

If the reason is because you want to select ALL, it is best not to
select anything and ignore this in your criteria.

Depending on what your query is for, you can usually find another way to
use criteria.

For instance, if you are using the query to filter records for a form,
you can have the form show all records and apply a filter. The same
thing applies to reports.

If you need more help, please describe what you are using the query for.

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top