title: Need to create a copy of an record in the same Access table and then update the data
body: <p>I am using the access 2016 inventory database which will not get larger that 20000 records.
  I updated the inventory table with the multi selection fields that I require to manage my inventory and everything is working fine in term of adding new records and updated existing records using the add and update macros in the tables forms.</p>
  
  <p>Now I want to be able to create a copy of an existing record, make an update and then save it in to the same inventory table so I have an historical data of updated parts and then update the form to only show the latest record</p>
  
  <p>I very new to access and coding so I'm sure I'm breaking some sort of modelling rule and have tried the following to get this to work with no success:</p>
  
  <p>***Creating updated record in same table
  *create a append query but access does not support muilti selection fields
  *create a macro to copy and paste the existing record to update and paste the new version of the record into the inventory table (Seems Copy and Paste are not support in Macro)
  *create a VBA that create a copy of the existing record, I can get this to create a copy but this only works after I have made the update to the record, which means I am left with two copies of the update record and not the original and updated record</p>
  
  <p>*** filter the Form to only show the latest record
  *No idea where to start!</p>