getkrishpm

Hai everyone, I dont know how to update the stock in my program. Actually, I am having two forms one is to enter the opening stock and the other to enter the usage of stock. In the opening stock form i select the item purchased and enter the date of purchase, shop name, quantity, rate, amount and the opening stock, which is the quantity bought.

In usage of stock form again i select the item ,enter the date of usage and the quantity used. In the balance textbox i want to display the balance which is the opening stock minus usage. It can work for the first time but if i enter another entry in usage of stock form for the same item the balance text box should show the balance correctly, ie previous balance - current usage. The opening stock should be the same. What i have to do, i send the table design and form design please help me ,is there any modifications has to be done in the design.

DRW

DB1 (Access2000?) Only contains tables not forms!

If you are trying to read a value from the database then base the textbox on a query of the table.

i.e. in the properties of the textbox select data and in the Control Source select the field you want.

e.g.

=[Dayusage]![Balancestk]

When you need an updated value of this field than refresh the textbox.

e.g. 'text0.Requery'

I am not an expert in VBA but this should work.

getkrishpm

Thanks all i got the problem solved.