I need to log deletions of records and copy the deleted record to a table. I've tried a few different examples but cannot get them to work properly. VB Novice over here.
The best way is to add a flag field (Yes/No) to signfy archived/deleted
records. Add criteria to all your queries to not pull archived/deleted
records unless you are doing stuff with history.
Just add a checkbox on your main data entry form bound to the
archived/deleted field. Once checked they disappear after closing the form.
As Karl points out, you can save yourself a lot of work if you don't "move"
the records from table to table.
You didn't mention the volume of records you're dealing with ... if you have
millions of rows and/or your db is over 100 Mbytes and growing, you might
actually need to move records (or move up to a db engine with greater
capacity).
