Duplicate Record with New Primary Key (VBA)
<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>