AboutScottGem Expertise I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.
Experience I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.
Question Can you tell me in Acess 2007 how to enable a combo box for multiple selections? We want to be able to select multiple answers from a dropdown list...
Answer You can't. Comboboxes cannot do multiple selections. However, LIST boxes can by turning on the Multi-Select property. Look up multi-Select in Access Help for details on how to use the multiple selections. There is also a new datatype for Access 2007, that allows you to add multiple values, but I do not recommend it since it limits the scalability of your database.
Depending on what these selections are and what you want to do with them, you may be better off using a child table.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
