I simplied a form to isolate the problem. The 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 (using multiple tab controls for organization).
When I add a record from the main form (bypassing subform), a record is added to EMP table. If fill out both main and subform parts, 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 the subform, doesn't know a new record has been created in the main form. If I leave new record after completing the main form and then return, I can fill out the subform and it saves the data to the new record. Just 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 the main form).
Thanks.
When I add a record from the main form (bypassing subform), a record is added to EMP table. If fill out both main and subform parts, 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 the subform, doesn't know a new record has been created in the main form. If I leave new record after completing the main form and then return, I can fill out the subform and it saves the data to the new record. Just 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 the main form).
Thanks.