Updating a field

[EPNICO]

Question: I have three fields in my form that I do several calculations. qtyadded qtypulled qtyonhand. All of them are double integers. qtyonhand has an initial value of 1000. What I want to do is if I enter qtyadded or qtypulled it subtracts or adds from qtyonhand creating a new qtyonhand value and the new value is written to the record. Is this possible in Access I tried several ideas with no luck. Any help is appreciated.

Thanks

Epnico

 

[Neal]

You should be able to set the after update events of qtyadded and qtypulled to:

qtyonhand = qtyonhand + qtyadded
and
qtyonhand - qtyonhand - qtypulled