ACCESS VBA SELECT

I have four of these open recordsets in my code. For some reason this one keeps throwing a syntax error and/or a runtime error that Iam missing an operand. Any help would be appreciated I’ve spent hours trying to debug this.

Set ShpCstcnn = CurrentProject.Connection
AmtRst.Open “Select * from tblStdShipCost Where ShpCstCode = ” & ShpCd, ShpCstcnn