Hi Guys, please can you help. I have a form based on the “BookingTbl”. To save the user time, I have put a CommandButton which will duplicate the details of a specific booking. The code I used for this was generated by the wizard and is:

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70

Ie: Select Record ; Copy Record ; Paste Append

The problem I am experiencing is that Access is not recognizing the BookingID of the records appended to the BookingTbl this way. (BookingID is an AutoNumber field) So now when I try and add a new record to the BookingTbl, it will use the same BookingID as one of the duplicated record and then tells me that I can’t save the record because it would create a duplicate value in an index. Why does it do this?

Any ideas would help
Thanks
Liz

It is copying the auto-number field, and since paste does not invoke the create record routine it is never overwritten. I'd recommend doing a SQL append operation, drawing the values from the form and the auto-number should take care of itself then.