Adding the same record into 2 databases at the same time

[Tenmakk]

Hello. The way my program runs is that when a button is clicked on the form it will create a record, export it to excel, then it deletes it from the table. So basically the record is created and deleted with the button click, leaving me with a blank table (as designed).

I would like to send of a copy of the records I initially created into another "backup" table. This way, I'll have a table of all the records. I would have a backup of the records and will be able to keep track of and manage everything created.

I can't seem to figure out what to do. The best I can find on the net is that this is considered to be "bad code," but I can't find an actual way to do this.



Thank you.

[pbaldy]

If the table is in the same db, you can execute an append query before deleting.

[Micron]

Why bother deleting the first one? If you want to get at this "backup" from another db, just link from it to the first table. That way, it will be available in either one.

[Tenmakk]

OK. Thanks. It was easier than I thought.