sql语句,要适当加上单引号如
"U pdate {入库记录表} set 出库数量 = " & n & " where 料号 = '" & e.Table.Current("料号") & "' and 收货fa piao号 = '" & e.Table.Current("收货fa piao号") & "'"