Multiple Selection from A List Box, to a Table

[RxPain]

All,

I have a database in MS Access I have created for Employee training. What I want to accomplish is a Way to select employees who have completed a training course, and then save that data to a table.

Example:

A drop down list of training classes, and a list box with employee names.

I want to be able to select the course, then select all of the employees who attended the training, use a button to record the training into a separate table that stores the information of who took the training.

I know the basics on making list boxes, and drop down list, but not how to;

a. make it so I can select multiple names from the list box.
b. Join the selected class to those chosen in the list box.
c. How to use a button to put this data into a table where the training is recorded.


I have a table with all employees, and a table with all the courses, and other tables with information I may use.

The basic premise is using this as a kind of attendance recording. I select the course, instructor, date, from field and list, then use the list box to select all the employees who attended, click a button and it takes the information and inserts into a table with the below columns.

TrainingName Supervisor DateofTraining Attendees



Is it possible? I know its a lot to ask but I've been reviewing videos and information on the web and it seems to be all pieces that I cannot get to work together.

Any help, advice or direction is appreciated.

 

[pbaldy]

Does this help?

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

 

[MajP]

You can do this, but it will be a lot of code because that is just the beginning I would think. I assume when you move to a course you would want to prepopulate the list with those already attended. You would want to delete from the list. Etc.

You are probably better off just having a main form with courses and a subform to select people.