Decrease product inventory count as items are removed.

[CriminalTruth]

Hi i created an access 2003 dmb that tracts inventory by a production number. Now i need a way to decrease the inventory as it gets removed from inventory which a clerk would input.

i know the basics of how it would be done but im not sure how to call the sql function i would need to write.... or even how to write the sql function.

Here was my idea and maybe you can help?

they would input the production number?

they would input a number that would reflect how much of that specific item to deduct from inventory.

then it would find that record.

It would subtract they number they inputed from the value of the number of items in the inventory

If the inventory is 0 or less i want to delete the record
if it is above 0 i want to update that record.

my problem is that i dont know how to A) find that specific record and passing the argument to vba

and then i dont know how to delete the record in vba

pretty much i dont know how to do anything anymore cause i havent done vba in about 3 years :(

[pbmods]

Changed thread title to better describe the problem.

Moving to the Access forum....