If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

copy a record as new version

have data in access database. this database has many tables i.e 50.
data filled in various froms in visual basic and then send to all these tables
related to one record.
i have a requirement of creating a new version of an existing record means
make a copy of the exisitng
record and save it as latest so that user can make changes in it and previous
record becomes a part of
record history.

I am able to find the latest exisitng record using a recordid field. After
that i need to append
a new record and copy the values of existing latest record into newly appended
record.Hwo can i achieve this in shortest way.