automatic updating of records

[mistaking]

I am currently developing a stock control system on Access 2000
One problem when I record a product order and it is saved I want the database to automatically update the Product table to increase the "on-order" record by one, then when it is recieved decrease it and increase the "in stock" record and a few other similar things, although I assume they are all done in the same way.
The question is how do i do this, what do i use ?

 

[dazza76]

What I would do is create a couple sql queries.
like
so
Dim dbs As Database
Set dbs = CurrentDb
dbs.Execute("UPDATE Table SET Table.[counter] = [counter]+1
WHERE (((Table.productid)= '"& id &"'));"
dbs.close