Subtracting from units In Stock

Originally Posted by nicekul

I am having problems subtracting from unitsInStock for all records on my table, for instance; I have Quantity sold, Unit Price,UnitsInStock,Total sales, Stock Balance.

I declared
Dim num1
Dim num2
Dim num3
As General Declaration, then on form load

I wrote
num1 = quantity Sold
num2 = unitsInStock
num3 = Stock balance
num3 = num2 - num1

it worked just once and do not work anytime I update, again it dont work for all my records. Can anyone help please?

Originally Posted by Killer42

Yes, keep in mind that the Form_Load event only occurs when the form is loaded (strange, huh). From the sound of it, you want to do this in an event that is triggered when you change between records or something.

I think we'd need more detail on your situation to provide much more help.