In the onclick event of your submit command button is where I would place the logic to subtract the [sold_qty] from the [on_hand] field.
You may want to place some logic that checks for attempts to over sale the items too... new question... new thread.
I would suggest looking at the Access 2007 Northwinds_Trader template. Open your access 2010/2013, in the ribbon>file> new database
Search for "Desktop Northwind 2007 sample database" and download.
This database may very well do what you want without any modifications (well, updating the data to match your needs ;-) ); however, it's intent is to be a tutorial database. This version uses a lot of embedded macros in the forms; however, there are plenty of VBA examples etc...
I would look at the [orders details] form and its associated code.