Multiple Selections in a Combo Box

[BeStout]

I'm trying to essentially create a "select all" option in my combo box and then when I press a button on my form, I'd like each value from the combo box to be a separate entry in a table.

Specifically, I am selecting a supplier in another combo box, which narrows down the part numbers in the combo box I am having trouble with. Then I'd like to select all of the part numbers and have a row for each in my datasheet.

Is this possible? I really appreciate any help.

[ItsMe]

Your combo is based on an SQL statement. You could replicate this statement using VBA and retrieve the same records logically, then apply the data retrieved to your form's controls.

There is not a multi select option for combos. There is a multi select option for List Box controls.

[John_G]

Hi -

First, combo boxes don't have a multi-select option - you have to use a list box.

From what I can see, there is no "select all" option for selecting items in a list box. What you could do is put a "Select All" checkbox on your form, near the list box somewhere, and then the code behind the command button could process all the list box rows if "Select All" was checked, otherwise it would check each listbox row to see if it was selected (more-or-less normal processing).

HTH

John

[ranman256]

The would really work better as a table of values rather than a multi select combo.
The user selects items in a list, they append to a table.
This table of selections is linked to the main data table to retrieve the picked items.
No code, only queries. Select all appends all items query. Select 1 appends 1 item query. A query to empty the list to start fresh. A query to delete 1 item.

[BeStout]

John,

Thanks for the help. Is there any way you could help me with what that code for the check box would be?

Brad

[ItsMe]

Here you go

https://www.accessforums.net/code-re...box-43002.html

[John_G]

Hi -

You don't need any code behind the checkbox itself, you only need to check its value.

Supposing the checkbox is called SelectAll, you might have something like this:

'
' Scan through all the listbox items
'
 For J = 0 To listboxname.ListCount - 1
      '
      ' If the listbox item is selected OR the Select All box has been checked
      '
      If me!SelectAll  or listboxname.Selected(J) Then
      '
      '  Process the list item
      '
      End If
  Next J

replace listboxname with the actual name of your listbox control.

You would probably use this in the code for a command button.

HTH

John