Edit an old entry with a form

I have created a database that does not allow duplicates. I have also created a form that auto populates with all the information that is in that current field. I need to edit the information in that field so that it will be updated. However when I try to save the work that I have done it tells me that I is going to create a duplicate and it will not go through. So, how to I fix this so that it overwrites the old data. Thanks in advance for your help!!!!! I don't know if it matters or not but I am in access 2016

It sounds like your changes are creating a duplicate.

Cburn024 said:

I have created a database that does not allow duplicates.

I have also created a form that auto populates with all the information that is in that current field.

Click to expand...

How, exactly, are you doing each of these things?

What constitutes a duplicate record?

Linq ;0)>

normally youd open a form with ONLY that 1 record
docmd.openform "myForm",,,"[id]=" & me.id

then that is the only record that can be saved.
If you are using a query instead of a form, use an update query for that ID only.