If you are using a form/sub form, and have the Master/Child Linking field properties set,t hen you are tell Acess to handle the update.

With a query, you have to do it manually.