Document Editing Problems

How to Keep Combo Box Values When Reopening a Microsoft Access Form

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to ensure that values populated from a combo box into text boxes remain visible and do not disappear when closing and reopening a Microsoft Access form.

Product: Microsoft Access
Device & OS: not provided
Scenario: Populating dependent text boxes with data selected from a combo box on a form.
Observed behavior: Values placed in unbound text boxes disappear upon reopening the form, even though the selected combo box value remains stored separately.

Before you start

Ensure you have design view access to the form and understand whether the populated data needs to be permanently saved to your database table or just displayed temporarily for the user.

Solution 1Recommended

Use Bound Controls and the AfterUpdate Event

Use this method if the values populated from the combo box need to be permanently saved in the underlying record.

Unbound controls do not store data in the underlying table, which is why their values disappear when a form is reopened. To retain data across sessions, the controls must be bound to a field in your database.

Bind the Text Box

Open your form in Design View. Select the text box, open the Property Sheet (F4), and set the Control Source to the specific field in your underlying table where the data should be saved.

Configure the Combo Box Event

Select the combo box, navigate to the Event tab in the Property Sheet, and locate the AfterUpdate event. Do not use the Change event, as it triggers prematurely during typing.

Add Update Logic

Add a macro or VBA code to the AfterUpdate event to push the selected combo box data into the bound text boxes whenever the user makes a new selection.

Data Permanence: By using bound controls, the form will automatically load and display the saved values from the table each time it is reopened.

Solution 2

Configure ControlSource with Combo Box Column Indexes

Ideal when you only need to display related information on the form without saving it to the underlying table.

Solution 3

Concatenate Fields in the RowSource

A streamlined approach to display multiple pieces of data in a single unbound text box by combining them directly in the combo box query.

Free Microsoft Office alternative

Manage Your Data Effortlessly with WPS Office

While Microsoft Access is a specialized database application, many users find that WPS Spreadsheet offers powerful, user-friendly data management and filtering features for everyday tracking needs without the complexity of building custom forms. Try WPS Office as a lightweight, comprehensive productivity suite.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the Suite: Run the downloaded setup file and follow the brief on-screen instructions to install the software.
3. Open Your Files: Launch WPS Office and instantly open your existing spreadsheets and documents with perfect formatting preservation.

100% compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight installation that runs smoothly on Windows, Mac, and Linux.Familiar, intuitive user interface for seamless migration from Microsoft Office.Rich set of data management tools, pivot tables, and advanced formulas in WPS Spreadsheet.

microsoft office alternative - wps office

Frequently Asked Questions

Why do unbound text boxes clear out when reopening an Access form?

Unbound text boxes are not connected to a field in an underlying table or query. Therefore, any data placed in them is only stored temporarily in the application's memory and is discarded the moment the form is closed.

What is the difference between the Change and AfterUpdate events in Access?

The Change event fires every time a single character is typed or modified, which can trigger incomplete or error-prone data updates. The AfterUpdate event fires only after the user has finished making their selection and commits the data, making it the proper trigger for populating dependent fields.

How do I reference a specific column in an Access combo box?

You can reference a column using the Column property in an expression, such as =[ComboBoxName].Column(index). Note that column indexes in Access are zero-based, meaning the first column is Column(0), the second is Column(1), and so on.

Document & File Issues