Copying Primary key to another field in Access.
- by BashLover
Hey, I'm struggling to copy the Primary Key to another field in Access.
This is irrelevant , but clarifying on what I'm comparing.
... WHERE Tunniste=" & [Tarkiste] & ""
Tunniste = Primary Key , Autonumber , ID (Generated by Access.)
Tarkiste = This is the field I want to copy it to compare it.
I'm open to suggestions, I've already try'ed with Form_Load, using the following code.
Private Sub Form_Load()
DoCmd.RunSQL "UPDATE Korut SET [Tarkiste]=('" & Tunniste & "');"
End Sub
But this copied the same key to all the entries in "Tarkiste" field.
In simplicity I want 1:1 copy of field "Tunniste" to "Tarkiste" , whichever method it takes.
Started from this question. File Picker Replaces All Rows With The Same Choice.