Multiple Subform

[ezybusy]

Hi,
I am working on a patient registration database project. And one patient must have 2 emergency contact.
I created a form for patient and added two subform on it for the two emergency contacts. (NOTE THAT I DON'T WANT TO USE CONTINUOUS FORM OR DATASHEET).
When inserting record, everything works, but upon closing the main form and re-opening it the two subforms distals only details of the first emergency contact associated with the patient.



NB: Table Patient and Emergenecy contact have a one to many relationship

PLEASE SEE ATTACHED DATABASE SAMPLE.

Any help please

[aytee111]

Put both contacts on one subform. Either that or add a number to the table for contact 1 and contact 2. There needs to be a criteria for each of the subforms.

[RuralGuy]

Why do you not want to use a Continuous Form?