I have a form with 3 subforms. They are all correctly linked.
Main form is
MainID (PK auto)
field1
field2
etc
Subform 1:
subform1ID (PK auto)
MainID (FK to mainFormPK 1 to n)
field1
field2
etc
Subform2
subform2ID (PK auto)
MainID (FK to mainFormPK 1 to n)
field1
field2
etc
Basic setup. However, when entering a new record, when I enter one of the subforms from the main form, I am automatically taken to the last record in the recordset?!
The record I entered is saved, but I need to navigate back to the record I was just at in order to enter into the subforms.
WHat could be causing this?
Main form is
MainID (PK auto)
field1
field2
etc
Subform 1:
subform1ID (PK auto)
MainID (FK to mainFormPK 1 to n)
field1
field2
etc
Subform2
subform2ID (PK auto)
MainID (FK to mainFormPK 1 to n)
field1
field2
etc
Basic setup. However, when entering a new record, when I enter one of the subforms from the main form, I am automatically taken to the last record in the recordset?!
The record I entered is saved, but I need to navigate back to the record I was just at in order to enter into the subforms.
WHat could be causing this?