Keep getting "compile error: Method or data member not found" on this insert into statement. It is highlighting the "Me.txtSM3". The textbox exists and the reference is spelled correctly so I'm not sure where to go from here.
Code:
sqlStr = "INSERT INTO SavedRecords(Inspector, OrderNum, PCNumber, LogoPart, PhSpec, OrderName, TotalPieces, TotalIssues, GlueIssues, SeamIssues, PassFail, FPY, SizeIssues, ColorIssues, Comments, ProductIssues, SeamMsr1, SeamMsr2, SeamMsr3, SeamPull1, SeamPull2, SeamPull3, CutFibers, MissingCoating) " & _
" VALUES('" & Me.txtQI & ",'" & Me.txtJobnum & "','" & Me.txtpc & "','" & Me.txtLogopart & "','" & Me.txtPH & "','" & Me.txtjobdescription & "','" & Me.txtTotalpieces & "','" & Me.txtTotalissues & "','" & Me.txttotalglue & "','" & Me.txttotalseam & "','" & Me.txtPassfail & "','" & Me.txtFPY & "','" & Me.txttotalsize & "','" & Me.txtcolorissues & "','" & Me.txtComments & "','" & Me.txtproductissues & "','" & Me.txtSM1 & "','" & Me.txtSM2 & "','" & Me.txtSM3 & "','" & Me.SP1 & "','" & Me.txtSP2 & "','" & Me.txtSP3 & "','" & Me.txtcf & "','" & Me.txtmissingcoating & "')"
Attachments
Last edited: