Command Button to select multiple records in Drop down

[okitamura]

Could someone tell me how to make a multiple selection by a single click on the Command button? I know it will be an event procedure on the CMD button but I do not know how to code this in VBA. The selection is always the same. Lets say that you see the following in the Dropdown(Combo Box): Apple, Orange, Banana, Water Melon, Milk. This list could increase over time to include other types of groceries.
But single click on this command button will always highlight Bannana and Water Melon and Milk. This is so that users would not have to do CTRL + Click when they know this sepcific combination will always remain constant.

Any code exmaple will be great! Thank you in advance.

Sam

 

[lupins46]

You cannot select multiple items in a dropdown list.

 

[okitamura]

I apologize it is a Combo Box that I am trying to do multi-select. You can do this manually. I wanted to achieve it by VBA. I should have clarified.

 

[PHV]

Again, only ListBox may have a MultiSelect property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AlanJordan]

There are a number of third-party controls that allow you to do this. Desaware is reputable vendor:

http://www.componentsource.com/cata...UTHORDESAWA&sc=CS&sk=0&cv=bu&SERC=GGC1&bhcp=1

Here's a link to a Google Search:
(

http://www.google.com/search?hl=en&lr=&q=custom+controls+for+msaccess&btnG=Search)

They cost money, and using them will make your project slightly harder to distribute and maintain.

You could also try subclassing the combo box in Visual Basic. However, I haven't built a custom control in several years, and my skills in this area are out of date and I don't have VB or .Net installed at this location, so I can't help. Maybe, someone else can jump int.

Good luck.

Alan