Add New Combo Box List Values in Microsoft Access
Question details
Add values to an Access combo box list as users enter data, including in a database shared by multiple employees.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Employees need to enter records and add new choices to a shared combo box list.
- Observed behavior
- A combo box used directly in a table does not expose the NotInList event needed to add a new value through an event procedure.
Identify the table and text field that store the list values, and check that users have permission to add records to that table. The example below assumes a single-column text list; an ID-based lookup requires a different setup.
Use a bound form and the combo box NotInList event
Use this approach to let users add a new text value while entering a record through a form.
This example assumes a source table named ListValues with a text field named ValueName, and a form record field that stores the same text. Adapt the table and field names to your database.
Select the table or query containing the records, then choose Create > Form Wizard and create a form for data entry.
Open the form in Design View and add a combo box. In its Property Sheet, set Control Source to the record field, Row Source Type to Table/Query, and Row Source to SELECT [ValueName] FROM [ListValues] ORDER BY [ValueName];. Set Limit To List to Yes.
In the combo box Property Sheet, select the Event tab. Set On Not In List to [Event Procedure], then click the ellipsis button to open the VBA editor.
In the generated NotInList procedure, enter the following code, keeping the procedure name Access created: Dim qdf As DAO.QueryDef On Error GoTo AddError Set qdf = CurrentDb.CreateQueryDef("", "PARAMETERS [pNew] Text (255); INSERT INTO [ListValues] ([ValueName]) VALUES ([pNew]);") qdf.Parameters("pNew").Value = NewData qdf.Execute dbFailOnError Response = acDataErrAdded Exit Sub AddError: MsgBox "The value could not be added: " & Err.Description Response = acDataErrContinue
Save the form, open it in Form View, and type a value that is not in the combo box list. Confirm that the value is added and can be selected in a record.

Split the Access database for multiple users
Use a shared back end and a local front end for each employee who uses the form.
Work with Office files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for easier migration. It does not replace Access forms or run Access NotInList events.

Frequently Asked Questions
Can I use NotInList directly in an Access table?
No. Use a combo box on a form, then configure its On Not In List event in the control's Property Sheet.
Why isn't the NotInList event firing?
In the combo box Property Sheet, check that Limit To List is set to Yes and On Not In List is set to [Event Procedure]. Test by typing a value that is not already in the list.
What does acDataErrAdded do?
Setting Response to acDataErrAdded tells Access that the event procedure added the value. Access then requeries the combo box list so it can use the new entry.
Does the text-list example work for an ID-based lookup?
Not without changes. If the combo box stores a numeric ID while displaying text, the procedure must add the text to the lookup table and handle the new ID and the combo box's bound column.
Where should employees open a split database?
Each employee should open a local front-end copy. Its linked tables should point to the back-end file in a shared network location, which can be checked through External Data > Linked Table Manager.




