Well the issue is are you trying to update through an objects event, or strictly through code. If you have a form attached to a table, you don't need to be messing with VBA, however if you want to strictly do it through VBA then I would look into DAO recordsets.
Ex.
Dim db as DAO.Database
Dim...