I want to create some code that will delete printers from my printers table and automatically move them to a deleted table. I want to have this code do everything automatically. I am going to create a form that will ask what printer I want to delete, and when I type the name of the printer, all of the information that goes along with that printer will move into a table called tblDeletedPrinters. We need to do this so that when we delete one of our printers, we can have the information in a table in case we need to run queries on the data. Can someone help me with this?

Public Function Deleted_Yes_AfterUpdate()
On Error GoTo Deleted_Yes_AfterUpdate_Err

    Dim rstUpdRec As New ADODB.Recordset
    Dim sqlUpdRec As String
    Dim intPrinterId As Integer

    Dim strPrinter_Name
    Dim strDeleted_Yes

    intPrinterId = Screen.ActiveForm.PrinterId.Value
    strPrinter_Name = Screen.ActiveForm.Printer_Name.Value
    strDeleted_Yes = Screen.ActiveForm.Deleted_Yes.Value

    If IsNull(intPrinterId) Then
        DoCmd.CancelEvent
    ElseIf IsNull(strDeleted_Yes) Then
        DoCmd.CancelEvent
    Else
        '---------------------------------------------------'
        ' Update PrinterID Record on tblDeletedPrinter table '
        '---------------------------------------------------'
        sqlUpdRec = "SELECT * FROM tblDeletedPrinter WHERE PrinterId = " & intPrinterId
        rstUpdRec.Open sqlUpdRec, CurrentProject.Connection, adOpenKeyset, adLockPessimistic

        If rstUpdRec.EOF Then
            rstUpdRec.AddNew
            rstUpdRec("Printer_Name").Value = strPrinter_Name

            ' Add here other fields to be inserted. Same as above.

            rstUpdRec.Update
            rstUpdRec.Close
            Set rstUpdRec = Nothing

        Else
            rstUpdRec.Close
            Set rstUpdRec = Nothing
        End If
    End If

Deleted_Yes_AfterUpdate_Exit:
    Exit Function

Deleted_Yes_AfterUpdate_Err:
    MsgBox Err.Description
    Resume Deleted_Yes_AfterUpdate_Exit

End Function

You want code. Try this code.
Note you need to add other fields to be inserted in the tblDeletedPrinters.

John