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:
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:Code: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