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".
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".