I have an application that has a tabbed form as the main input screen. The first tab populates a couple of preset fields on the form to create a new record when the form is opened. The second tab has a subform that is linked to the first tab by one field (ApplicantID) and has it's own key field (ApplicationID). This also has a couple of fields that are populated on open to create a new entry. The next tabs also contain subforms and these are drawn from the same table as the second tab. However as soon as I start entering data on them they create a new record with a new ApplicationID number. How do I get these subforms to go to the same record as the first subform?

For those people who've viewed this question. Would it make more sense if I posted the database in question?