Others

Store People in a Microsoft Access Form with a Bound Combo Box

Khadija KhanKhadija Khan Nov 20, 2026 868 views

Question details

The user needs to store multiple people and their roles for each grievance in an Access form.

Store People in a Microsoft Access Form with a Bound Combo Box
Product
Microsoft Access
Device & OS
not provided
Scenario
A grievance can involve several people, and each person can participate in multiple grievances in different roles.
Observed behavior
An unbound combo box displays the same selected person across continuous-form records and does not save a separate person for each record.
Before you start

Check that Grievances and People each have a primary key and that the Roles junction table contains fields linking to both tables. Identify the field used to link each Roles record to its grievance and confirm that CustID identifies a person.

Solution 1Recommended

Bind a People Combo Box to a Roles Subform

Use this design to save a separate person and role for each grievance participant.

The Roles table represents each person's involvement in a grievance. An unbound control has no per-record field to store its value, so it can show the same selection on every row of a continuous form.

1
Check the relationships

Open Database Tools > Relationships and confirm one-to-many relationships from Grievances to Roles and from People.CustID to the corresponding person field in Roles. Include a role field in Roles to identify each person's capacity in the grievance.

2
Create the main form

Create or open a form whose Record Source is the Grievances table. Enter and save a grievance before adding its participants.

3
Add a Roles subform

In Design View, add a subform based on Roles to the Grievances form. In the subform control's Property Sheet, set Link Master Fields to the grievance key on the main form and Link Child Fields to the matching grievance field in Roles.

4
Bind the person selector

Add a combo box to the Roles subform. In its Property Sheet, set Control Source to the Roles field that stores CustID, and set Row Source to a query that returns CustID and a recognizable name from People. Set Bound Column to 1 and Column Count to match the query; use Column Widths to hide the ID column if desired.

5
Restrict and test selections

Set the combo box's Limit To List property to Yes. Open the main form in Form View, add several Roles rows with different people and roles, then navigate away and return to verify that each selection was saved.

6
Add a new person when needed

Open the People form, add and save the new person, then requery the combo box so the new entry appears. If no requery command has been set up, close and reopen the grievance form before selecting the person.

Bind a People Combo Box to a Roles Subform
Use your actual field names: The grievance key and the person field in Roles may have different names in your database. Their data types and values must be compatible with the related primary keys.
Free Microsoft Office alternative

Manage Grievance Lists in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with office files. Use WPS Spreadsheets for grievance lists and move compatible files between WPS and Microsoft Office. It does not fix or replace Access forms and relationships.

Organize grievance and participant lists in spreadsheetsOpen and save Microsoft Excel XLSX filesUse a familiar interface for a smoother move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the same person appear on every row of my Access form?

An unbound combo box is not connected to a field that stores a value for each record. In the combo box's Property Sheet, set Control Source to the person ID field in a record source such as the Roles table.

Should I create the grievance or the person first?

Both the grievance and the person must exist before you can link them in a Roles record. You can create either first, then open the grievance form and select the person in the Roles subform.

How can I show names while storing CustID?

Set the combo box's Row Source to a query containing CustID and the person's name. In the Property Sheet, set Bound Column to the CustID column and use Column Widths to hide that column if you do not want to display it.

How do I find a grievance by the grievant's last name?

Create a query joining Grievances, Roles, and People. Add criteria for the grievant role and the desired People last name, then use the query to view matching grievances.

Why doesn't a newly added person appear in the combo box?

Save the new person in the People form and requery the combo box to refresh its Row Source. If you have not configured a requery command, close and reopen the grievance form.