multiple item select from a combo box - microsoft.public.access.formscoding

I want to use this as a navigational tool, rather than to "input" values into a database. This control will be on a form that sets parameters for graphical chart displays. One of the requirements is to be able to select multiple values from a 2nd combo box after a 'parent' 1st combo box determines what should be in the 2nd one. I have a couple of ideas of how to do this, but was just wondering if someone has already tackled something like this before. I suppose I could populate a temporary table that has yes/no values in it and display that in a subform (which scrolls) and have a button beside the subform. But short of trying that immediately, I wouldn't mind any other suggestions. Oh, also I am planning to create a formula that creates the string "a, d, f" to be used as my parameter after the multiple items are selected.

Why not have your second combobox a listbox instead? Then you could set the listbox property to multiselect. The rowsource of the listbox would be a sql string based on the selection in the first combobox. See listbox Selected property in vbHelp for an example. Damon "jonefer" <jonefer@discussions.microsoft.com> wrote in message news:1B410103-A272-4A29-BD9F-244BFA64013D@microsoft.com... >I want to use this as a navigational tool, rather than to "input" values >into > a database. > > This control will be on a form that sets parameters for graphical chart > displays. > One of the requirements is to be able to select multiple values from a 2nd > combo box after a 'parent' 1st combo box determines what should be in the > 2nd > one. > > I have a couple of ideas of how to do this, but was just wondering if > someone has already tackled something like this before. > > I suppose I could populate a temporary table that has yes/no values in it > and display that in a subform (which scrolls) and have a button beside the > subform. But short of trying that immediately, I wouldn't mind any other > suggestions. > > Oh, also I am planning to create a formula that creates the string "a, d, > f" to be used as my parameter after the multiple items are selected. >

I need for the control to take up the small footprint of the combo box and to be able to scroll also, can this be done? That's why I thought of a subform which you can squish down to the size of one textbox (except for 1/4" on the right side). "Damon Heron" wrote: > Why not have your second combobox a listbox instead? Then you could set the > listbox property to multiselect. The rowsource of the listbox would be a > sql string based on the selection in the first combobox. See listbox > Selected property in vbHelp for an example. > > > Damon > > "jonefer" <jonefer@discussions.microsoft.com> wrote in message > news:1B410103-A272-4A29-BD9F-244BFA64013D@microsoft.com... > >I want to use this as a navigational tool, rather than to "input" values > >into > > a database. > > > > This control will be on a form that sets parameters for graphical chart > > displays. > > One of the requirements is to be able to select multiple values from a 2nd > > combo box after a 'parent' 1st combo box determines what should be in the > > 2nd > > one. > > > > I have a couple of ideas of how to do this, but was just wondering if > > someone has already tackled something like this before. > > > > I suppose I could populate a temporary table that has yes/no values in it > > and display that in a subform (which scrolls) and have a button beside the > > subform. But short of trying that immediately, I wouldn't mind any other > > suggestions. > > > > Oh, also I am planning to create a formula that creates the string "a, d, > > f" to be used as my parameter after the multiple items are selected. > > > > >

Ok I'm using a listbox which I've set the multi-select property to 'Extended'. The dilemma I am having is that when I click the scroll bar, it changes the selection. For example if I select A and B and then I click the scroll bar to try to select other values, my A and B selection becomes UNSELECTED and only C becomes selected. "Damon Heron" wrote: > Why not have your second combobox a listbox instead? Then you could set the > listbox property to multiselect. The rowsource of the listbox would be a > sql string based on the selection in the first combobox. See listbox > Selected property in vbHelp for an example. > > > Damon > > "jonefer" <jonefer@discussions.microsoft.com> wrote in message > news:1B410103-A272-4A29-BD9F-244BFA64013D@microsoft.com... > >I want to use this as a navigational tool, rather than to "input" values > >into > > a database. > > > > This control will be on a form that sets parameters for graphical chart > > displays. > > One of the requirements is to be able to select multiple values from a 2nd > > combo box after a 'parent' 1st combo box determines what should be in the > > 2nd > > one. > > > > I have a couple of ideas of how to do this, but was just wondering if > > someone has already tackled something like this before. > > > > I suppose I could populate a temporary table that has yes/no values in it > > and display that in a subform (which scrolls) and have a button beside the > > subform. But short of trying that immediately, I wouldn't mind any other > > suggestions. > > > > Oh, also I am planning to create a formula that creates the string "a, d, > > f" to be used as my parameter after the multiple items are selected. > > > > >

Read the vb help on listboxes multiselect -Extended requires you to hold down the Shift key to make multiple selections. Simple selects or unselects by simply clicking the mouse on the selections you want. You may want to temporarily make your listbox larger until you are familiar with how it works. Damon "jonefer" <jonefer@discussions.microsoft.com> wrote in message news:A42CAA45-6B8F-41DA-9FA2-A8916716DF39@microsoft.com... > Ok I'm using a listbox which I've set the multi-select property to > 'Extended'. The dilemma I am having is that when I click the scroll bar, > it > changes the selection. For example if I select A and B and then I click > the > scroll bar to try to select other values, my A and B selection becomes > UNSELECTED and only C becomes selected. > > "Damon Heron" wrote: > >> Why not have your second combobox a listbox instead? Then you could set >> the >> listbox property to multiselect. The rowsource of the listbox would be a >> sql string based on the selection in the first combobox. See listbox >> Selected property in vbHelp for an example. >> >> >> Damon >> >> "jonefer" <jonefer@discussions.microsoft.com> wrote in message >> news:1B410103-A272-4A29-BD9F-244BFA64013D@microsoft.com... >> >I want to use this as a navigational tool, rather than to "input" values >> >into >> > a database. >> > >> > This control will be on a form that sets parameters for graphical chart >> > displays. >> > One of the requirements is to be able to select multiple values from a >> > 2nd >> > combo box after a 'parent' 1st combo box determines what should be in >> > the >> > 2nd >> > one. >> > >> > I have a couple of ideas of how to do this, but was just wondering if >> > someone has already tackled something like this before. >> > >> > I suppose I could populate a temporary table that has yes/no values in >> > it >> > and display that in a subform (which scrolls) and have a button beside >> > the >> > subform. But short of trying that immediately, I wouldn't mind any >> > other >> > suggestions. >> > >> > Oh, also I am planning to create a formula that creates the string "a, >> > d, >> > f" to be used as my parameter after the multiple items are selected. >> > >> >> >>

Similiar Articles:

multiple item select from a combo box - microsoft.public.access ...
I want to use this as a navigational tool, rather than to "input" values into a database. This control will be on a form that sets parameters for gr...

Multiple Item Forms - microsoft.public.access.forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I want a combo box on the top that will select an id number from a table ...

Selecting more than one value from a list or combo box - microsoft ...
multiple item select from a combo box - microsoft.public.access ... Selecting more than one value from a list or combo box - microsoft ... multiple item select from a ...

select multiple items from dropdown - microsoft.public.access ...
... that. i tried using combo-boxes, but that dosent work either ( like you mentioned in your post ) for access 2003, is there a way to select multiple items in a list box?

Combo Box Value that acts like multiple values - microsoft.public ...
multiple item select from a combo box - microsoft.public.access ... Combo Box Value that acts like multiple values - microsoft.public ... multiple item select from a combo ...

How to save data in lookup field from a combobox - microsoft ...
... save data in a lookup field from a combobox, lookup field and combo >data have the same items in the list , furthermore combo box is enabled to >select multiple items ...

pick multiple items in data validation - microsoft.public.excel ...
Hi, I'd like to pick two items from the picklist. ... on.ca/excelfiles.html#DataVal DV0017 - Select Multiple ... Data Validation Combo Box -- Click Data Validation ...

Multi-level combo box - microsoft.public.dotnet.languages.vb ...
multiple item select from a combo box - microsoft.public.access ... Multi-level combo box - microsoft.public.dotnet.languages.vb ..... in that the user can select an item ...

Multiselect combobox - microsoft.public.access
multiple item select from a combo box - microsoft.public.access ... "Damon Heron" wrote: > Why not have your second combobox a listbox instead?

Set Textbox value by selecting item from combobox but it must be ...
Bind the control for the text box but not the combo box. Use the AfterUpdate method of the combo box to get control when the item is selected.

Multiple-Item Controls: Working with ListBox and ComboBox Controls
Multiple-Item Controls: Working with ... event handler to add items to the combo box. Because you can have an empty list box, you should make sure that the selected item is ...

multiple item select from a combo box
I want to use this as a navigational tool, rather than to "input" values into a database. This control will be on a form that sets parameters for graphical chart

How to: Allow Users to Select Multiple Items in a List Box
You can, however, make it possible for a user to select multiple items in a list. ... in the InteractiveChange Event of a list box to display the selected items in a combo box ...

MULTIPLE SELECT COMBO BOX,MULTIPLE SELECT COMBO BOX Tutorial ...
Displaying search result for: MULTIPLE SELECT COMBO BOX Multiple select box ... want to populate data in it from database and on the basis of yhe selected item...:

7/20/2012 10:30:11 PM