update a field when another field is edited

J

JoeP

I want to automatically update my "Inventory" field in table1 when "Items
sold" in table2 is changed.
 
M

ManningFan

Don't we all...

You're going to need code that reads the ItemsSold record in table2,
adds or subtracts the appropriate number and then updates the ItemsSold
number accordingly. Without knowing more about your layout or
functionality I can't be of much more help than that.
 
Top