Multiple Selections in Combo Box?

[Guest]

I am trying to create a project experience database for my company. I want
to have a combo box to select the services our company provided on the
project, and sometimes there are multiple services on each (ex. mechanical
design, construction management). Is there a way to select multiple services
out of the one list, or do I have to have several boxes and select a
different service each time? Thanks in advance for any help.

 

[Bill Mosca, MS Access MVP]

Marcus

Combos give you only one item selection. A list box allows multiple
selections. Set the Multi Select property to Simple or Extended. Extended
lets you use Shift or Control while selecting.

 

[Allen Browne]

Where are you trying to store these multiple services?
In a field of your Project?

That's not going to work well. You need a related table to hold the services
used in the project. The fields of this ServiceInProject table will be
something like this:
ServiceID relates to Service.ServiceID
ProjectID relates to Project.ProjectID

The interface will be a subform in your Projects form.
Show the subform in Continuous form view, so you can enter multiple rows.