title: Duplicate Record with New Primary Key (VBA)
body: <p>I have a very large record that I'm trying to duplicate, then open a form with the new version with a new primary key ID. Can this be done in Access VBA without having to iterate through all the fields to copy the data?</p>
  
  <p>Thanks!</p>