J
John
The following sql statement works fine if the 3 txtboxes (txt...) have
info in them. If any one of them does not have info in them then a
syntax error occurs. I am having difficulty in resolving this if
there is no info in any of them. Can any one help out on this?
Thanks.
sql = "UPDATE BuiltList " & _
"SET StandardWarrantyLength = " &
txtContractWarrantyLength & ", " & _
"MaxWarrantyLength = " &
txtMaxWarrantyLength & ", " & _
"Reason = '" & txtReason & "' " & _
"WHERE PartNumber = '" & Forms!
xMultipleDeviceWarrantyInformationUpdate!
lstMultipleDeviceWarrantyUpdateList.column(0, intCount) & "' AND
LotNumber = '" & Forms!xMultipleDeviceWarrantyInformationUpdate!
lstMultipleDeviceWarrantyUpdateList.column(1, intCount) & "' "
info in them. If any one of them does not have info in them then a
syntax error occurs. I am having difficulty in resolving this if
there is no info in any of them. Can any one help out on this?
Thanks.
sql = "UPDATE BuiltList " & _
"SET StandardWarrantyLength = " &
txtContractWarrantyLength & ", " & _
"MaxWarrantyLength = " &
txtMaxWarrantyLength & ", " & _
"Reason = '" & txtReason & "' " & _
"WHERE PartNumber = '" & Forms!
xMultipleDeviceWarrantyInformationUpdate!
lstMultipleDeviceWarrantyUpdateList.column(0, intCount) & "' AND
LotNumber = '" & Forms!xMultipleDeviceWarrantyInformationUpdate!
lstMultipleDeviceWarrantyUpdateList.column(1, intCount) & "' "