choose multiple values from a drop down list

[Trying to Finish]

I have a database of facilities. Each facilities handles specific care
options. Can I use a drop down list and be able to choose mutliple care
options from this list for each facility? Or is there a better way to handle
this>

 

[Dale Fye]

You cannot select multiple items in a drop-down combo box. However, you
could use a listbox rather than the combo box. It has a Multi-select
property that allows you to select multiple items from a list.

However, the more important question is what do you want to do with the
items in the list once you have selected them?
1. Do you want to store them in a one-to-many table that maps "care
options" to facilities?
2. Do you want to generate a report?
3. ??????

Once we know what you want to do with the items in the multi-select list
box, then we can provide you with some more detailed advice.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.