Hello I'm having a single tiny problem which is..
The coding below is the coding for update the quatity...
and the problem is when I put checkbox to update the selected check it wouldn't work and actually I didn't know how to put the code for checkbox...
The coding below is the coding for update the quatity...
Code:
Dim sql As String sql = "UPDATE Parts SET Parts.StockLevel = [StockLevel]-[Forms]![IRForm]![OrderForm]![QtyUsed] WHERE (((Parts.ItemCode)=[Forms]![IRForm]![OrderForm]![cboitem]));" DoCmd.RunSQL sql