Subform and Combo Box

[Guest]

Hi. I have 2 tables. 1 table is employee information the 2nd table is
Project plus employee tied to that project. I have a form that shows project
numbers. I want to put a subform into this form to be able to select
multiple employees for the project using a combo box pull down. Is this
possible? TIA!

 

[Douglas J Steele]

By design, comboboxes are single select. You'll need to use a listbox to get
multiselect capabilities.

 

[Larry Linson]

... 2 tables. 1 table is employee information
the 2nd table is Project plus employee tied
to that project. I have a form that shows project
numbers. I want to put a subform into this
form to be able to select multiple employees
for the project using a combo box pull down.
Is this possible? TIA!

If you want to use a Combo Box to select one employee on each line in a
continuous forms view Subform, yes you could. And, from your description,
that seems to be what you want to do.

As Doug pointed out, Combo Boxes do not have a multiselect property as do
List Boxes, but it doesn't make much "database sense" to put all the
employees in the same record.

Larry Linson
Microsoft Access MVP