Amend data on a form and save as new record

[gregoryf]

I have created a form that shows data from the underlying table. There is a combo box that allows me to go to the record I want to amend.

After I amend the data on the form I want to save the data on the form as a NEW record.

What is the best way to go about this task?