How do i display the last record, edit it and save as new record?

[shellj]

After adding a new record, I would like this record to be left visible on the form, change certain fields and save it as a new record but currently I just overwrite the original record.

Can someone tell me what I'm doing wrong?

Thanks

 

[JR2913]

Why not create a command button on your form to Duplicate a record? Then you can edit the record you have copied (duplicated) as required.