Hi All,
I made a vba script to run INERT INTO sql from table.CVTemp to CA.Temp with WHERE, but it always get failed on sentence which is with WHERE... and I don't know what went wrong...Can someone pls help? Thanks in advance! =]
Btw, Me.ListInfo.Value is the value selected from listbox
Code:
DoCmd.RunSQL "INSERT INTO CATemp ( Origin, MAWB, Flight, ImportDate, Consignee, Qty, Wgt, HAWB, ShipmentNo )" & _
"SELECT CVTemp.Origin, CVTemp.MAWB, CVTemp.Flight, CVTemp.ImportDate," & _
"CVTemp.Consignee, CVTemp.Qty, CVTemp.Wgt, CVTemp.HAWB, CVTemp.ShipmentNo FROM CVTemp;" & _
"WHERE CVTemp.MAWB=" & "'" & Me.ListInfo.Value & "';"