Calculating fields in a form

[newbie]

I am trying to build a form for inventory control that will allow users
to either a)enter new stock qty, or b)remove stock as it is sold. I
then want to have the new stock total reflected in another field called
available stock.
Any ideas for what I need to do?

Many thanks,

Newbie

 

[Tom Wickerath]

Try the tutorial that Allen Browne has made available:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html

Tom
_______________________________________


I am trying to build a form for inventory control that will allow users
to either a)enter new stock qty, or b)remove stock as it is sold. I
then want to have the new stock total reflected in another field called
available stock.
Any ideas for what I need to do?

Many thanks,

Newbie

 

[SAC]

Make the control source:

=[txtNewStock] - [txtSoldStock]