How to Report a Microsoft Access 365 Form and Subform Bug
Question details
The user needs to report a suspected Microsoft Access 365 form and subform bug with enough information for others to reproduce and investigate it.

- Product
- Microsoft Access for Microsoft 365
- Device & OS
- not provided
- Scenario
- A form and its subform appear to use incorrect linked-field values, and the user wants to distinguish a configuration issue from a product bug before submitting a report.
- Observed behavior
- Incorrect linked-field values are suspected, but the exact symptoms and reproduction steps are not provided.
Open the affected database and identify the main form, subform control, and fields used to link them. Record the Access version from File > Account and check whether the behavior can be reproduced consistently.
Check form and subform linking settings before reporting a bug
Use these checks to rule out incorrect linking properties or reserved names that can resemble an Access bug.
Right-click the main form in the Navigation Pane and choose Design View. Select the subform control on the main form, then press F4 to open its Property Sheet.
On the Property Sheet's Data tab, inspect Link Master Fields and Link Child Fields. Confirm that the master field identifies the intended parent record and that the child field is the corresponding field in the subform's record source. If multiple fields are listed, verify that their order matches.
Open the parent and child tables in Design View and inspect the linked fields. Confirm that their data types are compatible and that the form and subform record sources include the required fields. For an AutoNumber parent key, the child foreign key is typically a Number field with Field Size set to Long Integer.
Inspect table, field, and control names in the Navigation Pane and Design View. If a name is an Access reserved word, test a descriptive, nonreserved replacement in a copy of the database and update references in queries, expressions, macros, and VBA.
Save any changes and switch the main form to Form View. Move between parent records and repeat the action that produced incorrect linked values, recording the expected and actual results.

Submit a reproducible Access bug report
Use this approach if the behavior persists after checking the linking configuration or if you need help confirming whether it is a product defect.
Use WPS Office to Document Your Access Bug Report
WPS Office is a free, lightweight alternative for preparing the documents and spreadsheets that accompany an Access bug report. Its familiar interface and Microsoft Office format compatibility make it easy to move reporting materials between suites. It does not replace Microsoft Access or fix form and subform database bugs.

Frequently Asked Questions
Where do I find my exact Access version for a bug report?
Go to File > Account and record the version and build under Product Information. Select About Access for additional version details and the 32-bit or 64-bit installation type.
Where are Link Master Fields and Link Child Fields located?
Open the main form in Design View, select its subform control, and press F4. On the Property Sheet's Data tab, look for Link Master Fields and Link Child Fields. These properties are on the subform control, not the standalone subform object.
Can incorrect subform records be caused by settings rather than a bug?
Yes. Incorrect Link Master Fields or Link Child Fields values, incompatible linked-field types, or reserved words used as object names can cause unexpected behavior. Check these items and retest before treating the issue as a confirmed defect.
What should a sample database include?
Include only the objects and test records needed to reproduce the issue, such as the parent and child tables, relevant queries, main form, subform, and required code. Remove confidential data and credentials, then verify that the sample still reproduces the problem before sharing it.
Can WPS Office open the Access database and fix the subform bug?
No. WPS Office is not a replacement for Microsoft Access and does not provide an Access database engine or form designer. Use Access to inspect and test the database; WPS Writer or Spreadsheets can help prepare supporting report documents.




