Generating a report based on a multi select listbox.

[Derock]

Not sure if this is where I post this, but here it goes. I am having trouble generating a report based on the selections in a listbox. Right now I have a form that has a combox and listbox on it. I have it setup where I make a selection in the combobox and it outputs that selection to the listbox. I am able to generate a report when I select one item in the listbox, but I want to be able to select multiple items. When I turn on the multi select option for the listbox and select multiple items it does not work. I have looked online for solutions and found some that might work, but the problem is that I am not sure how to manipulate the code to make it work for me. I am not very strong with VBA coding and could use some assistance. Any help would be appreciated. I can send the database if necessary.

[ranman256]

DONT use multi select list box. Instead have a 'pick' table, where the user dbl-clicks items in the list, an append query adds the item to the tPicked table.
Then to run the report, the query is joined to this 'tPicked' table to pull the selected items. No code.

The multi list box requires lots of code.
(see diagram)

[Derock]

I don't know if that would work. The list contains about 1500 items. I think that might be a little too much for this.

[June7]

Review http://allenbrowne.com/ser-50.html