update a table from a form

[bhrosey via AccessMonster.com]

HELP!!!!! OK, I have an parts inventory database that when the maintenance
people need a part, they look up the part and they need to enter a qty that
they took. There are also fields that show how many were ordered, received.
I have the form set up so that the QtyAvail = [qtyreceived]-[qtyused] and
that works fine.....once. I know we shouldn't store calc data in a table,
but how can I keep a running total of my inventory and also be able to run a
report showing all my parts, their qty's, etc... I'm desperate! Are there
any good inventory templates out there?

Thanks,
Bill R.

 

[Guest]

You can look at this Inventory Database on this Address. It's for microsoft
templates. Go to Databases and then Access 2003 and they have an Inventory
database there.

http://office.microsoft.com/en-us/templates/CT101426031033.aspx


Other than that without figuring this out and just shooting from the hip,
you may need to create a field that when a number is inputted(let's say qty
taken) is added to the qty used field and then subtracted from qty remaining.
This way, qty taken will continue to add to qty used and therefore continue
to take away from qty remaining. Just a thought, you will have to do some
work to find out if it will work for you.