Updating a form in ms access
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.
In this example, we've selected the Order ID fields. Now when you return to the subform properties window, you should see the "Link Child Fields" and "Link Master Fields" properties filled in.
Ed Sorry, looks like it's as simple as Application. Here is a clip from a good help page by Tony D'Ambra.
The url is Ed : Resize Form Controls You can use the Inside Height and Inside Width properties of an Access form to dynamically resize controls at run-time.
Now whenever the record changes in the form, the subform should refresh itself.
So, I prefer Open Query action rather than Run SQL action.