Form Combo Box to pick multiple items for a report 1

[molly]

Is it possile or is there a white paper on the following. I would like to make a combo box on a form that contains say 60 products. For simplicity, the underlying table has 2 fields: CustID and ProductID.

The objective is to pick say 10 products and run a report command button to see what customers takes these 10 products.

Can you point me in the right direction?
thanks, Molly.

 

[molly]

I would like to add: when i pick 10 products from the list of 60 products, would the pick method be something like holding the CTRL button while I mouse click the 10 products? Or is there an easier way?

 

[TheAceMan1]

How are ya molly . . .

Have a look at the [blue]Multi Select[/blue] property of a listbox . . .

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]