Posted this awhile back and it is still happening:
I have a form and subform that will not allow edits and I receive and error that it will create duplicate values in the PK when I try and edit any information. This happens right before I tab into the subform and have made changes to fields on the main form. I have the properties set to yes for Data entry, Allow Deletions, Allow edits and RecordSet type set to Dynaset.
The main form is giving the error when I attempt to save the record even before I get into the subform. I have two tables (1 for the main form and 1 for the subform) and the subform is connected via the Primary key of the main form. Is their a certain code I need to use in order to edit the data? I have ttried allow edits but it still does not work.
I have a form and subform that will not allow edits and I receive and error that it will create duplicate values in the PK when I try and edit any information. This happens right before I tab into the subform and have made changes to fields on the main form. I have the properties set to yes for Data entry, Allow Deletions, Allow edits and RecordSet type set to Dynaset.
The main form is giving the error when I attempt to save the record even before I get into the subform. I have two tables (1 for the main form and 1 for the subform) and the subform is connected via the Primary key of the main form. Is their a certain code I need to use in order to edit the data? I have ttried allow edits but it still does not work.