Main form table won't always update from subform entries. (yes, sometimes it does)
Posted on 2015-01-09
My database is split into front and bank ends.
I have two sets of forms, each form with a subform.
In the first form, I have a Class form with a Class table combo box.
The subform, Class Skills, for the Class Skills table, is linked by a Class ID primary key and foreign key in the Master/Child fields link property.
Adding Skills to the Class Skills form updates the Class Skills table with the name of the class and the skills taught.
In the second form, I have a Class form with a Class table combo box.
The subform, Class Roster, for the Class Roster table, is linked by a Class ID primary key and foreign key in the Master/Child fields link property.
Adding students to the Class Roster form "sometimes," not all the time, updates the Class Roster with both the Class name and the Student names, sometimes it just adds the student names and leaves the Class name blank.
Not to disuade from checking these again for something I may not have thought of, but I've checked the table relationships, form properties for Data Entry and Allow Edits, and Master/Child link field. I've created a new form.
I don't know where to go from here. Any ideas?