Can you make multiple selections?

[kuebs]

Hi, I am a pretty new Access user who is creating a financial tracking database at my work. Since I am the most technical, it became my job.

I have a table with a pull down list of items. Is there a way to have multiple items selected from that pull down list?

 

[WildHare]

Yes, there is a property for a LIST BOX which allows Multiple Selected items. Note that this does NOT apply for a COMBO box - so you'll have to change your control type from a combo to a list (at least I think you will - your question indicates a 'drop down list', which most people would interpret to be a combo box.


new Access user who is creating a financial tracking database at my work. Since I am the most technical, it became my job.

PS - No offense meant, but you don't need to be "technical" to use Access - you need to understand DATABASES. In fact, the more "technical" you are, sometimes, the more trouble you have with Access. Make sure you study a bit about relational databases and that stuff as you go about it. Good luck.



Jim Hare
"Remember, you're unique - just like everyone else"

http://www.jmhare.com

 

[kuebs]

Thank you for your help. I think I need to be more specific. To further clarify, it is a lookup column, that gives a dropdown list of choices.

 

[jebry]

Hi!

If you mean a look-up list in the table itself, then there is no way to choose more than one from the list. Storing more than one piece of data in any cell is considered bad database design and will cause serious maintainence and retrieval problems later. It sounds like you need to redesign the database and maybe add a table to store the information in question. You would then set a one-to-many link between the tables.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[kuebs]

That sounds more advanced than I am right now. Thanks for helping me. I am thinking about that advice and if I can impliment it.