When I enter information into two of my five subforms I get the following error: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
I am not sure why this is coming up especially becuase I have found a way around it. If I move ahead one record and the back again on the main form and then do the same on the subform in question (before entering any info), I can enter data no problem. The error will not appear.
Any idea what's going on?
I am not sure why this is coming up especially becuase I have found a way around it. If I move ahead one record and the back again on the main form and then do the same on the subform in question (before entering any info), I can enter data no problem. The error will not appear.
Any idea what's going on?
