I have a form based on a SALES table. in the form there are 2 unbound text values (L1PRODUCTID and L2PRODUCTID, both values are different)
there is an CLICK event which INSERTs into the SALES table (the INSERT works fine) . At the same time, I want to UPDATE my PRODUCTS table where the [PRODUCT].[PRODUCT_ID] = L1PRODUCTID
and UPDATE my PRODUCTS table where the [PRODUCT].[PRODUCT_ID] = L2PRODUCTID.
Update [PRODUCT]
Set [PRODUCT].[PRODUCT_IN_STOCK] = ([PRODUCT].[PRODUCT_IN_STOCK] - L1TXTQTLSOLD)
WHERE [PRODUCT].[PRODUCT_ID] = L1ProductId
Update [PRODUCT]
Set [PRODUCT].[PRODUCT_IN_STOCK] = ([PRODUCT].[PRODUCT_IN_STOCK] - L2TXTQTLSOLD)
WHERE [PRODUCT].[PRODUCT_ID] = L2ProductId
PROBLEM: i get a compile error 'SUB OR FUNCTION NOT DEFINED POINTING TO MY update STATEMENT
i DONT UNDERSTAND why i get this error