Button to clear a record, not working

[snipe]

Hey guys,

I have a form to "Un-Issue" tickets to a salesman. This form, when opened, copies all of the tickets for a selected salesperon that have "date rcvd = null" to a temporary table (T_CheckOut_Edit_Temp). Each record has a button "UnIssue" that has the code shown:

Private Sub Unissue_Click()    
    CurrentDb.Execute "UPDATE T_CheckOut_Edit_Temp SET DateIssued= Null, Type=Null, " _
        & "Salesperson=Null, SalesName=Null, Store=Null, Clerical=Null, DateRcvd=Null " _
        & "WHERE SerialNumber= Me.SerialNumber"
    Me.Requery
End Sub

It should set all of the fields to null, except serial number. All I am getting is "error 3061, Too few parameters. Expected 1." Here is a snipped of the form and the table that it is linked to:

[Bob Fitz]

Have you tried:

Private Sub Unissue_Click()
        CurrentDb.Execute "UPDATE T_CheckOut_Edit_Temp SET DateIssued= Null, Type=Null, " _
        & "Salesperson=Null, SalesName=Null, Store=Null, Clerical=Null, DateRcvd=Null " _
        & "WHERE SerialNumber= " & Me.SerialNumber
    Me.Requery 
End Sub

[June7]

Do not include variables within quotes - concatenate variables. Reference to form control as dynamic criteria is a variable. Bob's posting shows correction in the WHERE clause to concatenate variable.

[snipe]

Perfect. Thanks for the help guys!