If you are coping and pasting from a datasheet which contains an autonumber and trying to past that record into a new one, the autonumber is your issue, if set to unique. However, I have found that if using a form view with the autonumber or id (unique record) into the footer then copy and paste into a new record there seems to be no issue.
--- In [EMAIL PROTECTED], "CapitalLease" <[EMAIL PROTECTED]> wrote: > > I have a DB of customers some of whom I do business with multiple times > but for different reasons each time. I need to be able to copy the > record, "cut and paste" the record, to create a new identical record. > So far I am unable to do it. Any ideas? >
