On my consumable form I have a text box where the user would enter the quantity used and that gets sent back to the database. Then the user would click a button and update the quantity field with the new amount.
Or in other words quantity=quantity-quantityused
I've tried something similar to this but have had no luck
dim dbs as database,rst as recordset, strsql as string
strsql="SELECT * FROM [Consumables] WHERE [itemid]=" & Forms![order
Is there anyone out there who could point me in the right direction. Is there an easier solution for what I'm proposing to do to track inventory?
Thanks for any help I can get I'm really stuck here.