Update Field

ViRi

Registered User.
Local time
Today, 08:10
Joined
Jan 31, 2006
Messages
44
I have 2 numeric fields one called Sold the other SoldSum on a form called frmProduct.

Sold receives a value from another form when the user clicks on a button.

I would like SoldSum to add the values that Sold receives every time the Sold value changes

I have tried this code on the AfterUpdate event of the Sold Field
Code:
Dim Sold
Dim SoldSum

Set Sold = Forms("frmProduct")("Sold")
Set SoldSum = Forms("frmProduct")("SoldSum")
 
SoldSum.Value = SoldSum + Sold

I don't get errors but the SoldSum field is blank

ViRi
 
Last edited:

Users who are viewing this thread

Back
Top Bottom