Fix a Microsoft Access Subform That Does Not Filter by Customer
Question details
Configure a Microsoft Access subform to show lending records for the selected 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.
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.
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.
In the Navigation Pane, right-click Contact Details and select Design View.
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.
Click the border of the Current Lending subform to select the subform control, then open the Property Sheet.
On the Property Sheet's Data tab, set Link Master Fields to ID and Link Child Fields to Checked Out To.
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.

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.

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.




