Make changes to inventory quantity after a sell via form

[FriQenstein]

Hi all,



I'm trying to find the simplest way to create a for that will allow a user to make a basic addition or subtraction to existing inventory already in the DB table.

I'm using 1 main table for the main inventory. I will create a form to allow the user to search for the part number to verify they have the right item, then allow them to alter the total quantity in stock (either + or -), save that change and exit the form.

Most of the examples I'm finding aren't really explaining how to go about doing the modification to the item quantity. Some of the examples keep showing how to use an Update or Amend function, but that seems a bit over the top for what I'm thinking... unless I'm missing something altogether.

Could someone please shed some light on either a preferred method to doing this, or perhaps a link with an example that actually shows how to link up the information and execute the form to alter the quantity on hand?

Regards.

[June7]

Quantity on hand should be calculated when needed, not saved in table. Review http://allenbrowne.com/AppInventory.html

[davegri]

Have a look at this. Working system with Data dummied up.
Pay particular attention to the Adjust Stock button on the products form.
SampleInventory-davegri-v01.zip

[orange]

Here is a link to a free youtube video re Stock Management from Software Matters. It should give you some insight to design and development of a database for Inventory/Stock management.
Good luck

[FriQenstein]

Thanks for the insight guys.
I'll look in to those.