D
DistrautMan
ok i have an invoice in forms and i need to make an update query to update
each "in stock" value for every item i choose. i choose each item from a
drop down menu that has been requeried from a first drop down menu where i
select the category of the item and then input a quantity to the right of
that in a text box. how i do i create an update query that takes the
quantities for each item thats been selected and subtracts it from the "in
stock" field in it's table? i would prefer a button at the bottom that i
press to run the update and it updates each item on the invoice. please make
it detailed im new to access. thanks for the help.
each "in stock" value for every item i choose. i choose each item from a
drop down menu that has been requeried from a first drop down menu where i
select the category of the item and then input a quantity to the right of
that in a text box. how i do i create an update query that takes the
quantities for each item thats been selected and subtracts it from the "in
stock" field in it's table? i would prefer a button at the bottom that i
press to run the update and it updates each item on the invoice. please make
it detailed im new to access. thanks for the help.