Copy records using VB (1 Viewer)

[rhay]

I want to be able to archive my records for later retrieval.

How can I through VB, copy the contents of a record from a form to another table within the same database?

I plan on placing the code for this within the same module that deletes the record. So that when the person selects to delete the record it copies it to another table within the datatbase before deleting it for archival purposes.

Thanks,

Robert

 

[Rich]

Create an append query that does what you want the use the SQL statement. DoCmd.RunSQL"InsertInto etc;"