duplicating and editing a record via a form

[Gegsy]

Earlier this year I was daft enough to mention at work that I was interested in learning a bit about access databases. As a result of that my boss has set me the task of replacing some old Dbase IV databases with Microsoft Access. I have started with importing data from an old document database and sought a wee bit of parameter query help in this forum a couple of months ago. As a result of the direction I was pointed in I have produced a creditable search facility via forms for my new document database. I have now turned to the data entry via a form and have come to a grinding halt with reproducing a feature the old Dbase one had.

Once an entry for a new document was completed a message box would open asking if there was a second copy, with the answer no the entry would be saved and it would move onto the next new record. If the answer was yes it would duplicate the completed entry as a new record and modify the copy number +1 and save the record. This would be repeated for however many copies you had and until you answered. I have added a duplicate record command button to my form which works well but I have no idea how to modify the copy number field to reflect that this entry is for the second, third etc copies. Each document record has a seperate field for the copy number.

I would welcome any help you can offer or directions to where I can find the answer. Many thanks