Fix an Access Asset Subform That Does Not Update
Question details
The user needs the Asset subform to display records related to the currently selected Feature.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A Customer form contains multi-row Product, Feature, and Asset subforms representing one-to-many relationships.
- Observed behavior
- Customer, Product, and Feature records update as expected, but the Asset subform does not change when the parent selection changes. No error message appears.
Identify the Feature primary key and the corresponding foreign key in the Asset record source. In Design View, check whether the Asset subform control is inside the Feature form or is a sibling control on the main Customer form.
Link the Asset subform to the current Feature
Use this approach when the Asset subform control is placed inside the Feature form.
In the Navigation Pane, right-click the Feature form and select Design View. Select the Asset subform control, then open Property Sheet.
On the Data tab of Property Sheet, set Link Master Fields to the Feature primary key, such as FeatureID, and Link Child Fields to the matching Asset foreign key, such as FeatureID. Use the field names from your database.
In Property Sheet, check the Record Source of the Feature form and the Asset form. Ensure the Feature key and Asset foreign key are included and have compatible data types.
Save the forms, open the Customer form in Form View, and select different Feature records. Confirm that the Asset subform shows the assets for each selected Feature.

Connect sibling Feature and Asset subforms
Use this approach when Feature and Asset are separate subform controls on the main Customer form.
Work with Office files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and spreadsheets. It supports common Microsoft Office formats for an easier move between applications. It does not fix Access subform links or replace an Access database.

Frequently Asked Questions
Does Access limit a form to three nested subform levels?
Access does not generally impose a three-level limit. Check the subform control's Link Master Fields and Link Child Fields properties and confirm that the relevant keys are available in each form's Record Source.
Where do I find Link Master Fields and Link Child Fields?
Open the parent form in Design View, select the subform control, and open Property Sheet. Both properties are on the Data tab.
Why doesn't the Asset subform follow the selected Feature?
The link fields may be missing or mismatched, or the Asset and Feature subforms may be siblings on the main form. For sibling controls, expose the current Feature key on the main form and link the Asset subform to that control.
When should I requery the Asset subform?
If the Asset subform does not refresh after the current Feature changes, use the Feature form's On Current event to recalculate the main form and requery the Asset subform. Check that the Asset control is available when the event runs.




