Office Settings & Configuration

Fix a Microsoft Access Subform That Does Not Filter by Customer

Huda QurayshiHuda Qurayshi Nov 18, 2026 868 views

Question details

Configure a Microsoft Access subform to show lending records for the selected customer.

Fix a Microsoft Access Subform That Does Not Filter by Customer
Product
Microsoft Access
Device & OS
not provided
Scenario
A user opens a contact record in the Contact Details form and wants the Current Lending subform to show only that customer's lending records.
Observed behavior
The Current Lending subform displays records for every customer because it is not linked to the active contact record.
Before you start

Open the database in Microsoft Access and confirm that the Contact Details form's record source includes ID and the Current Lending subform's record source includes Checked Out To. The child field should store values that correspond to the contact ID.

Solution 1Recommended

Link the Current Lending Subform to the Contact ID

Set the subform control's master and child fields so Access filters lending records for the active contact.

1
Open the form in Design View

In the Navigation Pane, right-click Contact Details and select Design View.

2
Check the contact ID

On the General tab of the form, check for the ID field. If it is missing, use Add Existing Fields to add ID from the form's record source.

3
Select the subform control

Click the border of the Current Lending subform to select the subform control, then open the Property Sheet.

4
Set the link fields

On the Property Sheet's Data tab, set Link Master Fields to ID and Link Child Fields to Checked Out To.

5
Save and test

Save the form, switch to Form View, and move between several contacts. Check that Current Lending shows only the lending records for each selected contact.

Link the Current Lending Subform to the Contact ID
Check the underlying fields: If the link does not work, verify the field names in each form's Record Source and confirm that Checked Out To stores the matching contact ID, rather than only a displayed customer name.
Free Microsoft Office alternative

Use WPS Office for Customer Lists and Other Office Files

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move existing documents and spreadsheets into your workflow. It does not fix Access subform links or replace an Access database.

Organize and filter customer lists in WPS SpreadsheetOpen and edit Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX filesWork in a familiar, easy-to-use Office interfaceUse a free, lightweight suite for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Where are the Link Master Fields and Link Child Fields settings?

Open Contact Details in Design View, select the border of the Current Lending subform control, and open the Property Sheet. Both settings are on the Data tab.

What should the master and child fields be for this form?

Set Link Master Fields to ID and Link Child Fields to Checked Out To, provided those fields are available in the respective record sources and contain matching contact IDs.

Why does the subform still show the wrong records after linking it?

Check the Data tab of the subform control's Property Sheet for the link settings. Then inspect the parent and subform record sources to make sure ID and Checked Out To contain corresponding values.

Can WPS Office fix the Access subform link?

No. The master and child field settings must be changed in Microsoft Access. WPS Spreadsheet can filter customer lists in spreadsheets, but it does not replace this Access database feature.