delete button to somewhere else

[azhar2006]

Hello all
I created a query to the finished material effect put the delete button in this article form
It also put this code deletion button
The question is
I want to finished material effect does not delete the real but go to another table or query
Does not appear in the main table

Private Sub Command15_Click()
Dim intSeat As Integer
If MsgBox("Click ""Yes"" to Confirm you want to delete this record.", vbYesNo, "Delete?") = vbYes Then


intSeat = Me.Seat
CurrentDb.Execute "Insert into QurNearExp1 (Exp, DataInpuot, InputTo,namdrag,mom,item,iddrag) SELECT Exp, DataInpuot, InputTo,namdrag,mom,item,iddrag FROM QurNearExp WHERE Seat = " & intSeat
CurrentDb.Execute "Delete * FROM QurNearExp WHERE Seat = " & intSeat
Me.Requery
End If

End Sub
Is it possible to get an example of what I want

[ItsMe]

I would consider creating a Boolean field to indicate if the record is active or not. You are correct to not want to delete a record. The idea to move the record out of the table to a safe place is not a bad idea. I prefer to remove the record from the Recordset.

Forms and reports depend on Recordsets. The data a query returns will complete this recordset for the form or report. Adjust your queries to recognize the value of a Boolean (Yes/No) field. You can archive a record/row by updating the Boolean field and having the query not retrieve records where the Boolean value equals -1 or yes.

When you add a Boolean to your table, be sure to set the default to the desired value.

My preference for an "Archive" field would be a default of 0 or "No/False". Then, when I want to delete or archive the record, I change the value to -1 or "Yes/True".

[azhar2006]

Thank you very much ItsMe
But how do I do it
Is it possible ideas or example
My preference for an "Archive" field would be a default of 0 or "No / False". Then, when I want to delete or archive the record, I change the value to -1 or "Yes / True".
Thanks again

[ItsMe]

There are two queries in this sample DB. One will show the Archived records while the other will show the Active records.

The queries use criteria for the Archive field to distinguish the status of the records in the table.

[azhar2006]

Thank you very much ItsMe
Is what I want

[ItsMe]

I am glad to hear that it makes sense!