D
DistrautMan
alright i have a invoice form that uses a subform to select products. it
looks up the ID for each product and is bound to a table called suborders. it
also looks up its in stock value and then subtracts the quantity field from
it and then is bound to a field called in stock also in the suborders table.
i need to know how to take the new instock from the suborders and
update/append it to the table where all the inventory is stored. it should
overwrite the old "in stock" with the new one. how do i do this, i know it
has something to do with the criteria and i tryed putting the criteria as the
products ID but it doesnt work so maybe im entering it wrong but will someone
please help me.
looks up the ID for each product and is bound to a table called suborders. it
also looks up its in stock value and then subtracts the quantity field from
it and then is bound to a field called in stock also in the suborders table.
i need to know how to take the new instock from the suborders and
update/append it to the table where all the inventory is stored. it should
overwrite the old "in stock" with the new one. how do i do this, i know it
has something to do with the criteria and i tryed putting the criteria as the
products ID but it doesnt work so maybe im entering it wrong but will someone
please help me.