Keeping a running total for Liquor Inventory

Ok, so here is the problem.

I need to keep track of how much liquor I have in my store room. Liquor gets issued to the bar, banquets and the pool. In those columns I need those numbers to subtract to the current inventory total and blank out when I open up the workbook again. In the Inventory IN column I need that number to add to the current inventory total and blank out when i open it up again so i always have a current on hand number of the amount of liquor i have in the store room....soooo frusterating im close to getting it....im in the view code portion trying to write the correct code....please help! :-)

Cheers!

Attached is the form i made....