Mass enrollment form

[Ted C]

I have an Access 2003 database that tracks enrollment in corporate training courses. The main tables involved in this question are a Personnel table, a Class_Session table, and a Class_Attendance table.

The Class_Attendance table acts as the many-to-many relationship between Personnel and Class_Sessions.

My users want a form that will allow them to select many IDs from the Personnel table (with a checkbox, for example) and enroll them all into a single Class_Session simultaneously (i.e., multiple PersonnelIDs linked to a single Class_SessionID in a single pass).

I'm having trouble figuring out how to set that up.

[pbaldy]

One method:

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