关于库位数量削减的问题

yanwei82123300

各位老师给看看：关于库位数量不减少的问题
其中：Forms![frmStock_out]![STK]  为组合框
         Forms![frmStock_out]![BIN]   为组合框
        [Forms]![frmStock_out]![QTY] 为文本框
表为：tblLocation_remote
字段有 STK;BIN;Location_Qty
自从将窗体的STK,BIN,由文本框修改成组合框（因为这样可以进行库位的选取）以后下面的代码就不计算了！不知什么原因？请帮助看看，谢谢
SQLText = "UPDATE [tblLocation_remote] SET [tblLocation_remote].[Location_Qty] = [tblLocation_remote].[Location_Qty]-[Forms]![frmStock_out]![QTY] WHERE ([tblLocation_remote].[ITEM] = Forms![frmStock_out]![ITEM] and [tblLocation_remote].[STK]= '" & Forms![frmStock_out]![STK] & "' AND [tblLocation_remote].[BIN]= '" & Forms![frmStock_out]![BIN] & "' );"