Hello all!
I'm having a little trouble with an INSERT INTO and error 3075. My code is as follows (note: "txtQuantityShipped" is the only number):
Code:
Private Sub cmdRecordShipment_Click()
CurrentDb.Execute "INSERT INTO tblShipments(Part, Description, OldLocation, NewLocation, QuantityShipped, WhoReceivedParts, WhoAuthorizedShipment, ShipmentDate) VALUES (cmbPart," & Me.txtDescription & "," & Me.txtOldLocation & ", cmbBuilding, " & Me.txtWRP & ", " & Me.txtWAS & ", '" & Me.txtQuantityShipped & "', " & Me.txtDate & ")"
End Sub
I'm then getting the 3075 error on my description value:
Syntax error (missing operator) in query expression 'SWIVEL ASSY'
. However, the actual value in "txtDescription" is "SWIVEL ASSY, REMOTE CONTROL UNIT".
Is this an error in my code or is it an error with my value?