Store People in a Microsoft Access Form with a Bound Combo Box
Question details
The user needs to store multiple people and their roles for each grievance in an Access form.

- 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.
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.
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.
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.
Create or open a form whose Record Source is the Grievances table. Enter and save a grievance before adding its participants.
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.
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.
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.
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.

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.

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.




