Others

Fix an Access Asset Subform That Does Not Update

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

The user needs the Asset subform to display records related to the currently selected Feature.

Fix an Access Asset Subform That Does Not Update
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.
Before you start

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.

Solution 1Recommended

Link the Asset subform to the current Feature

Use this approach when the Asset subform control is placed inside the Feature form.

1
Open 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.

2
Check the linked fields

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.

3
Verify the record sources

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.

4
Test the relationship

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.

Link the Asset subform to the current Feature
Check each level: Also inspect the Product and Feature subform link properties if their selections stop updating. The Asset control must link to its immediate parent form when it is nested inside the Feature form.
Free Microsoft Office alternative

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.

Review tabular data in WPS SpreadsheetOpen and edit common Microsoft Excel formats, including XLSXWork with Microsoft Word DOCX filesUse a familiar interface for everyday document tasks
microsoft office alternative - wps office

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.