How to setup drop-down list to choose multiple items in Access?

[Guest]

I am trying to setup a test request database. I have been challenged with
standardizing the forms. I would like to setup drop-down lists, but would
like to be able to choose more than one item. Is this possible?

 

[Guest]

This is possible with a List Box but not a Combo Box. With the former, you
have to write code to parse the list or input it into a table. The
multi-select option is a property.

 

[Roger Carlson]

You can't use a combo box for multiple selections. Use a listbox with the
MultiSelect property set to Simple or Extended. However, you need to be
aware that you have to use code to read the values from the listbox.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CreateQueries2.mdb" (Form 6) which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

What is involved with writing the code, I am familiar with the basic
operations of access, never written code. Is this something I can do?
Thanks for you help!