G
Guest
Can anyone help me, I have 2 tables, one table "stock" has a field "QTY" the
second sub furm "Materials Subform" has a field "QTYUsed". What i want to do
is subtract the "QTYUsed" from the "QTY" . I am aware that i am probably not
structing the data correctly. I have a button on the form that i will click
to operate the code. I was thinking along the lines of the following
me.QTY - me[materials subform].qtyused = me.tempQTY
me.tempQTY = me.QTY
me.tempqty = 0
But it doesnt work, can anyone piont me in the right direction
second sub furm "Materials Subform" has a field "QTYUsed". What i want to do
is subtract the "QTYUsed" from the "QTY" . I am aware that i am probably not
structing the data correctly. I have a button on the form that i will click
to operate the code. I was thinking along the lines of the following
me.QTY - me[materials subform].qtyused = me.tempQTY
me.tempQTY = me.QTY
me.tempqty = 0
But it doesnt work, can anyone piont me in the right direction