Edit an old entry with a form (1 Viewer)

Cburn024

New member
Local time
Today, 17:22
Joined
Jul 20, 2017
Messages
1
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
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 21:22
Joined
Jul 9, 2003
Messages
16,245
It sounds like your changes are creating a duplicate.
 

missinglinq

AWF VIP
Local time
Today, 17:22
Joined
Jun 20, 2003
Messages
6,423
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.
How, exactly, are you doing each of these things?

What constitutes a duplicate record?

Linq ;0)>
 
Last edited:

Ranman256

Well-known member
Local time
Today, 17:22
Joined
Apr 9, 2015
Messages
4,339
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.
 

Users who are viewing this thread

Top Bottom