cmd1.CommandText = "Update {库存表} set 库存数量 =( Select 库存数量 From {库存表} where " & filter & ") + " & r("入库数量") & " where " & filter
像这一句,又有什么错呢?