OK, I think I am close to correcting this.
Code:
RecordSQL = "INSERT INTO DefectEvents (UPC, Category, Employee, Marketplace, Defect, CustomerName, OrderNumber, Status, CallNotes, DefectNotes, CallInit, Date_Time)" _
& "VALUES(" & Me.tbxProductUPC.Value & "," & Me.cbxDefectCat.Value & "," & Me.cbxEmployee.Value & "," & Me.cbxMarketplace.Value & "," & Me.cbxDefect.Value & "," & Me.tbxCustName.Value & ", & Me.tbxOrderNum.Value & ," & Me.cbxStatus.Value & "," & Me.tbxCallNotes.Value & "," & Me.tbxDefectNotes.Value & "," & Me.cbxInitiatedBy.Value & ",#" & dteDateTime & "#');"
My debug yields :
Code:
INSERT INTO DefectEvents (UPC, Category, Employee, Marketplace, Defect, CustomerName, OrderNumber, Status, CallNotes, DefectNotes, CallInit, Date_Time)VALUES(444555,Customer,Chris Freeman,Amazon,Did Not Receive,Bob Smith, & Me.tbxOrderNum.Value & ,Replacement Provided,None,None,,#1/31/2019 8:43:06 AM#');
But I am getting a Syntax Error (missing operator in query expression 'Chris Freeman'. It is putting the name of the control tbxOrderNum in the statement. I seem to be missing a delimiter.
Any advice?