Others

How to Fix Access ConcatRelated Parameter Prompt in Reports

Phi Hung Vo Sep 29, 2026 869 views

Question details

The user needs to resolve an 'Enter Parameter Value' prompt that appears when using the ConcatRelated function to combine multiple records in an Access report.

How to Fix Access ConcatRelated Parameter Prompt in Reports

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating or viewing a report that uses the ConcatRelated VBA function to combine multiple records.
Observed behavior: An unexpected 'Enter Parameter Value' prompt interrupts the report generation process, preventing the data from displaying correctly.

Before you start

Before editing VBA modules or report expressions, ensure you have a recent backup of your Access database file (.accdb) to prevent accidental data loss or corruption.

Solution 1Recommended

Rename the VBA Module and Correct Control Source Syntax

This solution resolves the naming conflict in VBA and ensures the ConcatRelated expression is properly formatted in the report's text box.

A common cause of the parameter prompt is a naming collision where the VBA module shares the exact same name as the function it contains. Renaming the module and ensuring flawless syntax in the report's Control Source will fix this issue.

Rename the VBA Module

Open your Access database and press ALT + F11 to open the VBA Editor. Locate the module containing the ConcatRelated function. If the module is named 'ConcatRelated', rename it in the Properties window to something distinct, such as 'basFunctions'.

Compile the Database

In the VBA Editor's top menu, click on 'Debug' and select 'Compile [Your Database Name]'. This verifies your code and saves the new compiled state.

Update the Report Control Source

Open your Access report in Design View. Select the text box where the combined records should appear, and open its Property Sheet.

Enter the Correct Expression

Set the Control Source property to the exact expression required: =ConcatRelated("[Medium]","[t Individual Pieces]","[Artist ID] = " & [Artist ID])

Verify Table and Field Names

Double-check your database tables to ensure that the table name 't Individual Pieces' and the field names 'Medium' and 'Artist ID' match your database spelling exactly, including spaces.

Syntax check complete: String concatenation in Access requires careful attention to quotation marks. The provided expression properly separates the fixed strings from the dynamic [Artist ID] reference.

Free Microsoft Office alternative

Looking for a Lightweight Productivity Suite? Try WPS Office

While Microsoft Access is a powerful tool for complex databases, most everyday document creation, data analysis, and presentations can be handled flawlessly with WPS Office. As a lightweight, all-in-one suite, it offers seamless compatibility with Microsoft Word, Excel, and PowerPoint files without the heavy subscription costs.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the Application: Run the installer and follow the on-screen prompts to set up WPS Office on your device in just a few minutes.
3. Open Your Office Files: Launch WPS Office and open your existing Word, Excel, or PowerPoint files to enjoy seamless, free editing.

Highly compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for smooth file sharing.Lightweight architecture that runs quickly and smoothly on almost any device.Familiar user interface so you can start working immediately with zero learning curve.Built-in PDF tools to view, edit, and convert PDF documents easily.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Access ask for a parameter value when using ConcatRelated?

This prompt appears when Access cannot recognize a field name, table name, or function name in your expression. It often occurs if the VBA module name is identical to the function name, which confuses the Access expression evaluator.

How do I compile my Access database after making VBA changes?

Open the VBA Editor by pressing ALT + F11, click on the 'Debug' menu at the top of the screen, and select 'Compile [Database Name]'. This checks your code for syntax errors and ensures your function is recognized by the application.

Do table and field names need to match exactly in the ConcatRelated expression?

Yes. Any slight typo, missing bracket, or omitted space in the table name or field names within the Control Source expression will trigger an 'Enter Parameter Value' prompt, as Access will treat the unknown name as a user-defined parameter.

Office Quick Solutions