Populate multiple records via check boxes

[sparlaman]

I've read through some of the posts here and found similar situations with
solutions but I just can't quite understand how to do this. I am trying to
use form controls i.e. checkboxes and/or multiselect list boxes to populate
multiple records from a related table. I have 3 tables: teachers, subjects, &
subjects_to_teachers. In the table "teachers_to_subjects" each record
contains one teacher & one subject. The purpose of this table is to relate
teachers to subjects in a many-to-many fashion.

I have a primary form which shows teacher info. What I want is a form
control on my primary form that will allow a user to select subjects per
teacher thereby populating my "teachers_to_subjects" table. I am guessing I
can do this via a subform but I am struggling with the rest. I would like to
use check boxes where the user checks all subjects that apply to a teacher
but I'm also interested in knowing how to use a multiselect list box to
perform this function as well.

If you understand what I mean and can help me accomplish this. I'll greatly
appreciate it.

Thanks in advance!!!
Sparlaman