I simplied a form to isolate the problem. Main form (EMP table as recordsource) uses 2 fields from EMP. The subform (also EMP table as r/s) has a tab control with 1 field from EMP table.
When I add a record from Main form (bypass Subform), a record is added to EMP table. If fill out Main AND Subform, I get: "The changes you requested on the table were not successful because they would create duplicate values in the index, primary key, or relationship..."
It apears Subform, doesn't know a new record has been created in Main form. If I leave new record after completing Main form and then return, I can fill out Subform. Can't fill them out simultaneously.
The master/child links on the subform appear correct. Interestingly, I added the linked field (Login) to the subform. As I add a new user on the main form the Login populates in the subform field, but the error still occurs (EMP table does not show the record until after I leave Main form).
Thanks.
When I add a record from Main form (bypass Subform), a record is added to EMP table. If fill out Main AND Subform, I get: "The changes you requested on the table were not successful because they would create duplicate values in the index, primary key, or relationship..."
It apears Subform, doesn't know a new record has been created in Main form. If I leave new record after completing Main form and then return, I can fill out Subform. Can't fill them out simultaneously.
The master/child links on the subform appear correct. Interestingly, I added the linked field (Login) to the subform. As I add a new user on the main form the Login populates in the subform field, but the error still occurs (EMP table does not show the record until after I leave Main form).
Thanks.