Create new record, and link it with new records in all other tables

[trolleri]

Watch below for database structure:


tblSubjects contains fields for identifying the subjects in a research. The other tables are to contain data tied to the subject (questionnaires etc.). Attached is my draft: 33 - English.zip

Demonstration (what works):


1) Open my database
2) In the list box, double-click one of the two records.
3) Watch how frmNavigation opens and you are able to browse through the different panes in the Navigation Form. All panes have subforms, which are meant for entering data into all other tables than tblSubject. The subforms are linked with tblSubjects via the SSN-field as shown in the picture above.

Problem (what does not work):
1) Open my database
2) Press the button "New"
3) Enter a new subject - you only need the fields "SSN" and "SubjectNo." to create a new record.
4) Press "Close" to go back.
5) Refresh by start searching - and search the new record you just created.
6) In the list box, double-click the new record you created.
7) You cannot save any data into the subforms, because you get the error "You must enter a value in the SSN-field".

How do I overcome this?

Ideas:
When creating a new record with frmSubjects, do I need to duplicate the entered value of SSN into all other tables as a new record?
Alternatively, can I make the subforms smart enough to automatically create a new record in their respective table, if no SSN-value matches the one I have looked up in the header of frmNavigation?

[trolleri]

Tab Control solves the above problem automatically, so I have decided to stray away from the Navigation Form, and use the Tab Control for subforms instead.

Then I will do the resizing of subforms manually.