"Marshall Barton" wrote ...
How do you want to display multiple departments on the form?
Maybe using a subform instead of all those check boxes??
Seems like you need a many-many junction table to keep track
of which students are in which departments.
I don't understand what you are saying about adding a field
to tblIncriptionTable??

In the tblInscription I will add the [Departement] field with these 3
values: "Philosophy";"Theology";"Pastoral" in the combo box. So that the
secretary will write only one of these 3 values through the frmInscription
for each student. She will keep on checking the programm boxes.