How can I create a Multiple Value Combo box on an Unbound Form

Posted by Jaffal on Stack Overflow See other posts from Stack Overflow or by Jaffal
Published on 2009-10-15T07:17:26Z Indexed on 2010/04/03 0:03 UTC
Read the original article Hit count: 386

Filed under:

combo

|

box

Hi

I need your help on MS Access 2007.

I have a big problem with my MS Access Unbound Form. How can I create a combo box i do not want bound to a table, show a multiple value List?

The Combo is named Sector and want these values to be selected in Multiples 9Which should be possible in Access 2007) from the Drop Down List: Fertilizer, Seeds, Pesticides, Veterinary products, Animal Feed, General.

Which Select Statement or VBA code can I use. I need a solution to handle this please.

Urgent Help needed please!!!

Looking forward for your response.

Thank you

© Stack Overflow or respective owner

Related posts about combo

Row Source - combo box, filtering what pops up in a combo box by date

as seen on Stack Overflow - Search for 'Stack Overflow'
so I have a combo box that I want to pop up when somebody wants to search by year. It will allow them to see in that combo box only results that happened in a certain year. so far I have something like SELECT DISTINCT Database_New.ASEC FROM Database_New WHERE (((Database_New.Date) >= DateValue('01/01/2001')… >>> More
When combo box is selected then display Combo Box and then when any Item in Combo Box is selected then make JTextField visible

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble with my code. What i'm trying to do is: 1. Create a Check Box, make it visible 2. When Check Box is selected display Combo Box, which will have few items for example ("1","2") 3. When 1 is selected from Combo Box then make 1 Text Field visible 4. When 2 is selected from Combo… >>> More
Technical Article - One Smart Combo

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Using Combo Box with List of Values >>> More
Frameworks: "One Smart Combo"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Let end users choose, search for, or manually enter valid values. >>> More
How do I add a toolbar to a region with ExtJS

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a border layout in ExtJS, The north region contains some HTML, but also needs to contain a toolbar like this... So i've managed to get the border layout set up, added the html to the North Region of the layout, but I can't find any workable examples of how to implement a tool bar. I have… >>> More

Related posts about box

Twitter Bootstrap styling conflicts with plug-ins like jqGrid and other third part libraries

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Issues:The concern is that the Twitter Bootstrap framework is that some of their css selectors are simply too generic and have incompatibility issues and conflicts with most third party plug-ins and css libraries, like jQuery-UI and jqGrid.My most pressing concern is only with the generic selector… >>> More
Check box and text box for Other value

as seen on Stack Overflow - Search for 'Stack Overflow'
When I have a set of either check boxes or radio buttons I often need to have an Other choice. This check box or radio button is very often accompanied by a text box where the user is supposed to fill out what this Other is. How do you usually handle this set up? What kind of markup do you use? What… >>> More
Clean and accesible Other option (Check box and text box)

as seen on Stack Overflow - Search for 'Stack Overflow'
When I have a set of either check boxes or radio buttons I often need to have an Other choice. This check box or radio button is very often accompanied by a text box where the user is supposed to fill out what this Other is. How do you usually handle this set up? What kind of markup do you use? What… >>> More
jQuery set selected value in option box once the box has been loaded

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to preset the value of a selectbox based on a hidden field. I need this after an error has been detected in a form to avoid the user having to set the value themselves again. I do this by setting the value of a hidden field server side. The problem I have seems to be that the select box isn't… >>> More
facebook connect box redirecting in the box not on the page

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a facebook connect application and I am just integrating facebook connect. So far, it does connect to facebook, however, it redirects to the page specified in the application settings in the dialog that appears instead of the page I was at. The dialog does not close and the page it… >>> More