Archiving data from a form

[pascaly]

Hi,

my db has a view data form frmJobsView. When I am done with a job (the db tracks jobs and workers and manages the status of a job) I would like to open the view job form and have a check box that on update to true, sends that job from the tblJobs to the tblJobsArchive. Does anyone have any tips on how I'd do this?

Thanks folks

 

[missinglinq]

Most people, rather than sending the record to a second table, would simply leave it in the original table. You base forms/reports on queries, where the Criteria for your checkbox field would be 0 (zero) in the query to show "active" records, and -1 in the query to show "archived" records.

 

[Mike375]

For most cases what missinglinq said.

If you want to shift the records from one table to another then

1) Make a copy of your table and with no records

2) Make an Append query with criteria based on your "job done" entry and a Delete query with the same criteria

3) With code or a macro run the Append query followed by the Delete query. Don't get the order wrong

 

[pascaly]

append query

Mike375, that's perfect! Exactly what I was looking for. I created the queries and stuck them behind the check box, it works great, thanks for the advice.