Hi, the field 'NewQuantity' is in a subform and has an integer. This value i want to store it in table 'products' , field 'StockRoom1'. I have try with following:
Dim SQL As String
DoCmd.OpenForm "SalesDetails", , , , acFormReadOnly
SQL = " UPDATE Products " & _
" SET Products.StockRoom1 = Forms![Sales]!SalesDetails.Form!NewQuantity " & _
" WHERE Products.IDProduct = Forms![SalesDetails].Form!IDProduct "
DoCmd.RunSQL SQL
Bat nothing , any ideas