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 :(