Saving multiple listbox selections

[trandel]

Hi,

I have a simple order entry system working with a subform containing combo box where a client selects various products from a table. These are recorded in separate table which allows for subsequent updating of the orders placed.

Now I want to refine this so that the user may make multiple selections as it is a bit laborious making 'n' single selections via a combo based subform.

Only a list box allows multiple selections but I would like some guidance on how to store and be able to recall and update the selected items.

Thanks and Regards

Tony Randell

 

[ejstefl]

You will need to loop through the list box and add each selected item to your orders table. These links describe how to use a multi-select list box as a query parameter, but should get you started:

http://www.mvps.org/access/forms/frm0007.htm

http://www.fontstuff.com/access/acctut11.htm