Multi Select List Box Problems

[Oblivinator]

First off, let me thank you all for reading about my problem. I appreciate it.

Ok so this has had me stumped for a while now. I've tried various ways to pull information from the Multi Select List Box. What I need is to pull the selected data and input them into various records. In my case I have lockers which are assigned to various customers. Each customer can have multiple lockers which range from 100-500. I have already created a table which stores the lockers from 100-500 with the customer's name that has been assigned said locker. Doing one locker one by one is rather tedious and cumbersome. I figured that an easier way would be to have a multi select list box which allows me to select the various different lockers and have them assigned to the customer.

Once I have this issue solved I can work on the main portion of it which would be just calculating their locker rent based on how many lockers they have and various other small details.

Attached is a screenshot of the form that I'm talking about. I would like to find out how to have the various numbers selected in the list to be entered into the table. The table just has the entire list of lockers from 100-500 with names. If a customer has multiple lockers then they should be able to be entered from using the multi select list box so that multiple entries aren't necessary. Thanks again for any help given!

[pbaldy]

Is this appropriate?

http://www.baldyweb.com/MultiselectAppend.htm

[rpeare]

Example database included!

Oblivinator.mdb

[Oblivinator]

Just checked out both of the provided answers and they are both great! Thank you so much. I really appreciate the help.

[mmahmod]

what if need to get back again to list in the file attached of Oblivinator.mdb
i mean to remove or delete the append in table and get back again in list

thanks in advance