Updating records in ms access
This will allow you to link your form to your subform, thus allowing your subform to automatically refresh whenever you change the record in the form.Click on the button with the three dots to the right of the property called "Link Child Fields". Next, select the fields that you'll use to link your subform to your form.If you are unable to find common fields between your form and subform, you can always place code on the "On Current" event of the form to refresh the subform. Scroll down until you find the property called "On Current".
Consequently if you later, as good practice, split your database the tables become attached tables and the code is likely to fail.After having found the record you can read or change the record's field values as explained under Edit a record in a DAO Recordset.