archiving

[Guest]

I am archiving information from one table into another by using an append
query and then a delete query to archive and clear the records. Is there a
code for copying a record and pasting it at the end of the form so I can
update the copy and archive the original.

 

[Joseph Meehan]

I am archiving information from one table into another by using an
append query and then a delete query to archive and clear the
records. Is there a code for copying a record and pasting it at the
end of the form so I can update the copy and archive the original.

Why not just make up a binary (yes - no)"archive" field and use filters
and or queries to filter out the archived data.

 

[Guest]

I need the original records information so i can update one of the fields.
The original record will be archived and the new record will stay on the form.

 

[Joseph Meehan]

I need the original records information so i can update one of the
fields.
The original record will be archived and the new record will stay on
the form.

"Joseph Meehan" wrote:

I don't see why that could not be accomplished while still keeping all
the data in one table. Remember that all you are doing is marking the
"archived" records so they can be hidden when you don't want to see them,
but it is very easy to view them when you want. I would think that using a
an archive field would make it easier.