Use ListBox on Form to capture multiple items 1

[nastar1]

Is there a way to use a Listbox on a form to allow the user to select multiple items from the Listbox and store all of those items in a table as well as on the Form itself?

If I write code against the Listbox, to write each selection by the user to a textbox, what options would I have to allow the user to remove any previously selected items from the textbox?

I dont want to use a subform unless it is considered to be the only possible way to accomplish this.

 

[Remou]

You can write separate items from a multi-select listbox to a table and you can remove them, however it will make all reporting difficult. It is generally best to write the items to a separate table or a link table:

[tt]tblItems
ID Description
1 Aardvark
2 Boar
3 Coypu
26 Zebra

tblMain
ID Description
1 Africa
2 Europe

tblMainItems
MainID ItemID
1 1
1 26
2 2[/tt]

You may wish to read

http://www.r937.com/relational.html