You didn't search? Not sure it will help, but sure:



Code:
      strSql = "UPDATE [bell-pos].POSReconciliation.dbo.SubmittedVoucher " _
             & "SET [RedemptionDate] = '" & Me.Dor_date & "', " _
             & "[RedeemedByEmployeeId] = '" & Me.Driver & "', [Status] = 10 " _
             & "WHERE VoucherID = '" & Me.txtInput & "'"

      PassThroughFixup "qryRedeemPOSVoucher", strSql, , False