Document Editing Problems

Fix Microsoft Access Multi-Value Lookup Fields That Do Not Save Selections

Anum MushtaqAnum Mushtaq Nov 14, 2026 869 views

Question details

The user needs an Access lookup field to save multiple category selections for each recipe.

Product
Microsoft Access
Device & OS
not provided
Scenario
A recipe form uses a value-list lookup with check boxes for categories such as Batters and Pies.
Observed behavior
Clicking OK after selecting categories has no effect, and the Category field remains empty when the user moves to another record.
Before you start

Identify the recipe table, its Category field, and the form control used to select categories. Close the form before changing the table design, and check that you can edit both the table and its records.

Solution 1Recommended

Check the Access lookup field and form binding

Use this approach to verify that the table field supports multiple values and that the form saves selections to the correct field.

Short Text can be the type of the individual values in a multi-valued lookup. Seeing Short Text in Design View alone does not establish whether the field supports multiple selections; check its Lookup properties.

1
Inspect the field

In the Navigation Pane, right-click the recipe table and select Design View. Select the Category field, then open the Lookup tab under Field Properties.

2
Check multiple-value support

On the Lookup tab, check that Allow Multiple Values is set to Yes. If the field cannot be configured for multiple values, create a new lookup field with Lookup Wizard and select Allow Multiple Values before finishing.

3
Verify the value list

On the Lookup tab, check Row Source Type and Row Source. For a one-column value list, use Value List and entries such as Batters;Pies, with Column Count and Bound Column both set to 1.

4
Check the form control

Open the form in Design View, select the category control, and open Property Sheet. On the Data tab, verify that Control Source points to the intended Category field and that the form's Record Source is editable.

5
Test a saved selection

Save the table and form, reopen the form, select one or more categories, and click OK. Move to another record and return, then open the table in Datasheet View to confirm the values were saved. If Access displays a validation or update error, correct it and repeat the test.

Existing field data: If you create a replacement field, verify and transfer any existing category data as needed before removing the old field. Once a multi-valued lookup is saved, its Allow Multiple Values setting cannot be changed back to No.
Free Microsoft Office alternative

Work With Exported Recipe Lists in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with exported recipe lists and other documents. It does not repair Access lookup fields or replace an Access database, but compatible Office files can be opened in WPS for everyday editing.

Review and edit recipe lists exported to a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with documents and spreadsheets in a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does a Short Text field automatically prevent multiple selections?

No. Short Text may describe the individual values in a multi-valued lookup. Open the table in Design View and check the field's Lookup tab, especially Allow Multiple Values.

Why do the check boxes appear but the selections do not save?

The control may not be bound to the intended multi-valued field, the lookup configuration may be incorrect, or the form's record source may not be editable. Check the control's Control Source in Property Sheet and the field's Lookup properties in table Design View.

How should I enter categories in a value-list lookup?

In the field's Lookup tab, set Row Source Type to Value List and enter the values in Row Source, separated by semicolons, such as Batters;Pies. For a single-column list, check that Column Count and Bound Column are both 1.

Can I turn a multi-valued lookup back into a single-value field?

After a multi-valued lookup is saved, Access does not let you change Allow Multiple Values back to No. Create a separate single-value field and transfer the appropriate data if you need a different design.

Can WPS Office fix the Access lookup field?

No. Change the lookup or form configuration in Microsoft Access. WPS Spreadsheets can be used separately to work with recipe data exported to an XLSX file.