What is the Form's RecordSource property? All a combo box does is take
data from one table (your School table I presume) and store one field
of it into another table, the Control Source field of the combo box in
the Form's Recordsource query.

I don't think it's *just* the combo boxes. It's something in the way
you have the Form set up. Normally, you don't need a save button, or
need to do anything other than move to a new record (using the *> icon
in the navigation buttons at the bottom of the form, or just tabbing
through the fields to the last one).

                 John W. Vinson[MVP]