How to Append Information to a Table from Multi Select List Box

[laniebe]

Hello! I have a form with an unbound multi select list box where I want to move 3 columns of information for each line selected to a new table. I also want the column information to be in separate fields in the new table.

My table with the information is called tbEmployees
My new table is tbHoursWorked

My form is frmHoursWorked

My fields are EmpID, Primary_Dept, Position

Thank you!!

[ranman256]

doing it that way requires a lot of coding,
but it you use single select box, then dbl-click the item,
the event would fire a query to pull all the fields in that event.

[laniebe]

Ranman! Thank you! I've been away from Access for a few years so I'm a little rusty. In normal circumstances I would not duplicate that information but we have to have it for historical purposes as the employees move around all the time with departments / positions. We have to keep their historical time log.

With that known, do you have any other ideas or suggestions to pull multiple employees information into a new table at the same time. There are over 500 employees so unfortunately doing them one at a time would take A WHILE.

Thank you for your input!

[ssanfu]

Here are examples of working with multi select list boxes: Use a multi-select list box to filter a report http://www.allenbrowne.com/ser-50.html Even though this is about filtering, just modify the code to add the records you need. The main thing is HOW to get the values selected in the multi-select list box. ClearList() and SelectAll() functions http://www.allenbrowne.com/func-12.html MultiSelectListboxes.mdb (intermediate) http://www.rogersaccesslibrary.com/forum/topic315.html MultiSelect.mdb (Intermediate) http://www.rogersaccesslibrary.com/forum/topic316.html

[ranman256]

dbl-clicking or mutli selecting a list of 500 both take the same time.

the dbl-click method requires no programming.