SQL statement not working

[phiberdelic]

I need help with this statement. I am getting "Expected end of statement" at &quot AND (PONumber BETWEEN "...please advise as to what I am doing wrong here I am not proficient in SQL statements and am just winging it.

If chkDateRange.Value <> 0 And chkPORange.Value <> 0 And chkLocation.Value <> 0 Then
rsRecordset.Open &quot;INSERT INTO tblDataHold(Vendor), tblDataHold(PONumber),&quot; & _
&quot; tblDataHold(ReceiptDate), tblDataHold(Location) SELECT Vendor, PONumber,&quot; & _
&quot; ReceiptDate, Location FROM ReceivingsHeader WHERE ((Vendor=&quot; & cmbVendors.Value & _
&quot AND (Location=&quot; & lstLocation.value &quot AND (PONumber BETWEEN &quot; & txtFromPO.value &quot; AND &quot; & txtToPO.value &quotAnd (ReceiptDate &quot; & _
&quot;between &quot; & txtStartDate.value &quot; and &quot; & txtEndDate.value &quot)&quot; & _
, cnCurrent, adOpenDynamic, adLockOptimistic;
End If

 

[VBslammer]

You missed several '&' between variables and strings, for example:

") AND (Location=" & lstLocation.value

&

 ") AND (PONumber BETWEEN "

See if this compiles:

rsRecordset.Open &quot;INSERT INTO tblDataHold(Vendor), tblDataHold(PONumber),&quot; & _
&quot; tblDataHold(ReceiptDate), tblDataHold(Location) SELECT Vendor, PONumber,&quot; & _
&quot; ReceiptDate, Location FROM ReceivingsHeader WHERE ((Vendor=&quot; & cmbVendors.Value & _
&quot AND (Location=&quot; & lstLocation.Value & &quot AND (PONumber BETWEEN &quot; & txtFromPO.Value & &quot; AND &quot; & txtToPO.Value & &quot And (ReceiptDate &quot; & _
&quot;between &quot; & txtStartDate.Value & &quot; and &quot; & txtEndDate.Value & &quot);&quot;, cnCurrent, adOpenDynamic, adLockOptimistic
VBSlammer