Save deleted or pre-updated record

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

Hi,

My form is designed for Allow Deletions and Allow Edits
both to Yes.

Could someone please advise how to save deleted record to
a separate table. Same thing for a record just before it
was updated.

Thanks in advance.

Carlos
 
Carlos,

You can use an Append Query to "copy" the record into the separate
table, prior to deleting it from the existing table.

Another approach, probably simpler in the long run, is to put an
additional field in the table, RecordStatus or some such, where you can
"flag" a record as archived/trashed/in longer relevant or whatever.
Instead of deleting it, I mean. And then, all of the functionality of
your application, such as forms and reports, can be based on a query
which selects the required records on the basis of this field.
 
Another approach, probably simpler in the long run, is to put an
additional field in the table, RecordStatus or some such, where you can
"flag" a record as archived/trashed/in longer relevant or whatever.
Click to expand...

What a brilliant, simple concept, which I had never thought of before, but
now lets me put back hundreds of records into the original table, instead of
having five other archive tables! Life really just gets better every
minute <grin>!

Thanks Steve, your post again proves the value of this newsgroup.

Right, off to watch the sport on cable with a few beers

The Goat Herder
 
Back
Top