In this video tutorial we show the use of update mode and add mode on a form - http://databasementor.com/basic-ms-access-lessons/basic-examples/cds-database/access-update-form/
