Multi Select items in a combo box

[shamilton785]

Hi, I am relatively new to access database. I have a table set up with a combo box in it. I want to be able to select several items from the combo box. Is this possible?

[missinglinq]

Multi-select is only available (at least in Access 2000, but I believe this is true for all versions) in List Boxes, not Combo boxes. Sorry!

Hi, I am relatively new to access database. I have a table set up with a combo box in it. I want to be able to select several items from the combo box. Is this possible?

[shamilton785]

Multi-select is only available (at least in Access 2000, but I believe this is true for all versions) in List Boxes, not Combo boxes. Sorry!

How do I do multiselect with a list box? I changed my box from a combo box to a list box and still do not know how to make it allow me to select more than 1 item from the list box. My list box is created within a table in Access.

[NeoPa]

With a mouse
click on your first item, then Ctrl-click on the other items.
With the keyboard
move around with the up- and down-arrow keys and use space, then ctrl-space to select your items.

[MMcCarthy]

How do I do multiselect with a list box? I changed my box from a combo box to a list box and still do not know how to make it allow me to select more than 1 item from the list box. My list box is created within a table in Access.

You have made the control type a listbox in the table but until you put it on a form as a control you can't do anything with it.

You can't program against tables which is why you will need to design a form for the table.

Why are you trying to select multiple values in a table on a list anyway.

A table record can only hold one value for any field at one time.

[shamilton785]

You have made the control type a listbox in the table but until you put it on a form as a control you can't do anything with it.

You can't program against tables which is why you will need to design a form for the table.

Why are you trying to select multiple values in a table on a list anyway.

A table record can only hold one value for any field at one time.

I have a database that has all of our parents and their information on it. The table is where I enter all of my information on the parents. I want to have a drop down box that lists all of our committee so that I can indicate which committee they are interested. Some families are interested in more than one committee and therefore I need to be able to multi-select. From the table I was going to creating a query and a report on the committee information.

[MMcCarthy]

I have a database that has all of our parents and their information on it. The table is where I enter all of my information on the parents. I want to have a drop down box that lists all of our committee so that I can indicate which committee they are interested. Some families are interested in more than one committee and therefore I need to be able to multi-select. From the table I was going to creating a query and a report on the committee information.

You can't hold more than one value per field in any record in a table. This defeats the whole purposes of databases. You should have a second table with this committee selection and a reference to the primary key of the first table.