There are two ways that you can refresh the subform whenever the record in the main form changes: When you're using forms and subforms in Access, generally you link your form to your subform with one or more fields. In our example, we have a form called Orders that has a subform called "Order Details".
If you right-click on the subform object and select the properties, you should see that there are two subform properties called "Link Child Fields" and "Link Master Fields".
Below the text boxes is a subform (set to continuous form), which displays the search results. There's not much advantage to resetting the Record Source every time, although I'm not sure if there's much disadvantage either. Principally In the Chield Field /s we enter information from the main form that concerns the subform!The relation is: the first field from Link Master Fields corresponds to the first field from Link Chield Fields! I have another issue that i want one field in the subform to be a combo box when one of the value selected, rest of the fields should be changed to match the selected value. Not sure if this is what you are looking for, but here is what I did for a similar situation.I have had a look and your relationships hasn't been set correctly, so I have altered the database you have add to your thread, look at the relationships and you will see 1 to Many has been set. At some point look up Normalization your database that will help.I also removed the Incident Log table, pointless if you are adding for each day just add the field to the day register.
I know the problem is with the auto increment field that is not updating, any way to do it ?? In function of the link the query may be updatable or not! In the properties you have to flook for Link master field and link chield field properties!