Copy Record

P

paul

Hi,

ive created a form that displays a record. I need to be able to copy the
entire record in to another table. Ideally, i want the code to sit behind a
button.

the form im talking about draws its record from a table called tblMain and i
want to copy the record on display to a table called tblMainArchive, can
anyone help me with the code to do this please...

paul
 
B

Bruce

You can probably do it as described, but I doubt very much that you want to.
Duplicate records are usually not good. An exception might be double data
entry for checking accuracy of critical records, but in such a case a query
is periodically run to remove duplicates, and in any case that doesn't sound
like your situation. If you need to archive certain records, why do you want
to keep them in the main table as well? Wouldn't you be better off with a
query? If you want to archive records older that a year or whatever, a Make
Table Query is almost certainly a better choice.
 
P

paul

Dave thanks,, your code worked but it only copies the first record in the
table and not the record that im viewing... any other thoughts on how i get
it to copy the record that im viewing ?

Paul
 
P

paul

dave, havent tried it yet but in anticipation of it working thanks for your
time !!!

paul
 
P

paul

Dave, i tried to change RecordsetClone to Recordset and it didnt work. it
could be because im using access 97 and when i type in Me. there isnt a
recordset option to choose? any other thoughts

regards,

paul
 
Top