Form update

H

Hubbymax

First, thank you all for the great help so far.

I have receivables form that has 3 fields I am having trouble with.

UnitsInStock
AddUnits
TotalUnits

UnitsInStock is drawn from a Products table, AddUnits is put in by the
user, TotalUnits is a sum of the first two fields. I would like to
have the UnitsInStock updated by the TotalUnits field once the sum for
the TotalUnits is done and the AddUnits field returned to "0".
 
Top