D
dinaC
I have main form based on a table, linked to a sub-form based on a junction
table. Everything is working pretty well except: The PK of the junction table
is an auto-number field and it is displayed in the subfrm. When I tab from
the main form to the subform, the autonumber field (PK of subfrm) is blank
until I enter a record into the Dr field (which is a look-up to the Dr table)
at which point the focus goes back to the auto-number field and a new
auto-number appears but instead of creating a new record, the form defaults
back to the first record. The new record is saved but I have to go to it and
continue entering the information.
Any ideas on what's wrong?
table. Everything is working pretty well except: The PK of the junction table
is an auto-number field and it is displayed in the subfrm. When I tab from
the main form to the subform, the autonumber field (PK of subfrm) is blank
until I enter a record into the Dr field (which is a look-up to the Dr table)
at which point the focus goes back to the auto-number field and a new
auto-number appears but instead of creating a new record, the form defaults
back to the first record. The new record is saved but I have to go to it and
continue entering the information.
Any ideas on what's wrong?