Hi,
I am cloning records in Access 2000 and once a record is cloned, I want to give a record number such as if I clone record with autonumber = 23 the cloned record will be = 23-a and if I clone 32-a will be given id of 23-b. This should be for any record within the database.
Right now when I clone a record is given a new unique autonumber.
Is there a way to acomplish that? If so how?
I think this maybe done through vba but I have no clue how and where to start.
Thanks
df
I am cloning records in Access 2000 and once a record is cloned, I want to give a record number such as if I clone record with autonumber = 23 the cloned record will be = 23-a and if I clone 32-a will be given id of 23-b. This should be for any record within the database.
Right now when I clone a record is given a new unique autonumber.
Is there a way to acomplish that? If so how?
I think this maybe done through vba but I have no clue how and where to start.
Thanks
df
