Others

How to Display Related Access Records in Datasheet Forms and Subforms

Olivia Miller Oct 20, 2026 868 views

Question details

The user needs to display all child records alongside their related parent records from linked tables in Microsoft Access Datasheet or Continuous Form view.

How to Display Related Access Records in Datasheet Forms and Subforms

Product: Microsoft Access
Device & OS: not provided
Scenario: Managing databases with one-to-many relationships between sources, impacts, and information controls, requiring a combined view of related records.
Observed behavior: Requires a method to properly link and display parent and child records across multiple subforms simultaneously.

Before you start

Ensure your database tables are properly designed with defined one-to-many relationships and that primary and foreign keys are correctly established before building your forms.

Solution 1Recommended

Use a Main Form with Synchronized Subforms

Create a main container form to host two subforms, linking the second subform to the first via a requery event to properly display related one-to-many records.

Microsoft Access does not allow you to place a subform directly inside the detail section of a Continuous Form. The best approach is to place both subforms side-by-side on an unbound main form and use VBA to synchronize them.

Create an unbound main form

Open Access, go to the Create tab, and select Blank Form. This will serve as the master container for your subforms.

Insert the first subform

Drag and drop your primary child record form into the main form. In the Property Sheet, set its Default View to either Datasheet or Continuous Forms.

Insert the second subform

Drag and drop the related information form into the main form. Set the Master/Child link fields so it references a hidden or visible key text box from the first subform.

Add VBA requery code

Open the Property Sheet for the first subform, navigate to the Event tab, and click the builder button next to 'On Current'. Add the code `Me.Parent!YourSecondSubformName.Requery` to ensure the second subform updates whenever a new record is selected.

Use a Main Form with Synchronized Subforms

View Compatibility: Once configured, both subforms will fully support continuous data viewing or datasheet layouts without displaying nesting errors.

Free Microsoft Office alternative

Looking for a Free Office Suite for Your Daily Tasks?

While Microsoft Access is a specialized database management tool, WPS Office provides a free, lightweight, and comprehensive suite for all your document, spreadsheet, and presentation needs with a familiar interface.

1. Download WPS Office: Navigate to the official WPS website and download the free installation package for your operating system.
2. Install the Suite: Run the installer file and follow the on-screen prompts to complete the quick setup process.
3. Open Your Files: Launch WPS Office and immediately open, edit, and save your existing Word, Excel, and PowerPoint documents without losing formatting.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly on older devices.Familiar user interface requiring no steep learning curve.Powerful spreadsheet features to handle robust data management and analysis.

Frequently Asked Questions

Can I put a subform directly inside a continuous form in Access?

No, Access restricts placing subforms into the detail section of a Continuous Form. You must use an unbound main form to host both the continuous form and the related subform side-by-side.

Why is my second subform not updating when I click different records?

The second subform must be told to refresh its data. Ensure you have added the requery macro or VBA code (e.g., `Me.Parent!SecondSubformControl.Requery`) to the 'On Current' event of the first subform.

What is the difference between Datasheet view and Continuous Form view?

Datasheet view displays data in a rigid grid similar to an Excel spreadsheet. Continuous Form view allows you to heavily customize the layout, add buttons, and format individual controls while still displaying multiple records vertically.

Office Quick Solutions