Jim -
The error message is telling you that you are trying to insert a duplicate. Check the indexing on the sub form's table to make sure there isn't a unique index on a field that should not have one.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@...> wrote:
>
> Hello all,
>
> I have a form with a subform on it. The users cannot add a record to the subform all of sudden. I went to a copy of the database from last month and it worked there. I thought the query was a not updateable query, so I copied the sql from the database that worked into the one that does not work and it did not change anything. I checked the master child links and they are exactly the same for both. I have compared all that I can and still see no differences, but continue to get the below error;
>
> The changes you requested to the table were not succesful 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.
>
> The tables looked to be the same, so I must be missing something. Anyone have any ideas.
>
> Thank You
>
> Jim Wagner
>
Tidak ada komentar:
Posting Komentar