listbox multiple control sources

[Guest]

I have a list box on a form, I have now idea how I send each item selected to
different control sources with every item selected.

I.E. User clicks items one, it goes to control source item1. User selects
another item and that goes to control source item2, etc.

Please Help M

 

[Allen Browne]

Do not use a multi-select list box like that.

For starters, it is very bad design to have repeating fields. This article
may be helpful:
Description of database normalization basics in Access 2000
at:
http://support.microsoft.com/?id=209534

You will need to create a related table to hold the many choices, and use a
subform where the user can enter as many rows as apply.