Others

How to Report a Microsoft Access 365 Form and Subform Bug

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 868 views

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.

How to Report a Microsoft Access 365 Form and Subform Bug
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the subform control

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.

2
Verify the linked fields

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.

3
Check field availability and data types

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.

4
Review potentially reserved names

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.

5
Retest the behavior

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.

Check form and subform linking settings before reporting a bug
Select the control, not just the subform: Link Master Fields and Link Child Fields belong to the subform control on the main form. Opening the subform object by itself will not show those linking properties.
Free Microsoft Office alternative

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.

Use WPS Writer to organize reproduction steps, screenshots, and expected versus actual results.Work with Microsoft Word .docx, Excel .xlsx, and PowerPoint .pptx files when sharing supporting materials.Use a familiar Office-style interface to migrate report documents with minimal adjustment.Prepare supporting documents with free, lightweight office tools; Access database testing still requires Microsoft Access.
microsoft office alternative - wps office

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.