Access Question

[racerxfactor]

I have a database that keeps track of inventory. I have a table and a form with stock on hand. If I change the values from the form it will change the values in my table and vice versa.

I was wondering if there was a way I can instead of changing the values; where I can input an amount that was sold and have that subtract from the table of stock on hand.

[doctorgonzo]

That would be a very simple operation. You could do it in several ways, such as in an Update query or through VBA. Probably simplest would be an update query, such as

PHP Code:

PARAMETERS Sold Long;
UPDATE table SET AmountOnHand= [AmountOnHand]-[Sold] WHERE [InventoryCode]=...