Others

How to Save Combo Box and Text Box Values to an Access Table

Camila Milosovich Oct 15, 2026 870 views

Question details

The user needs a method to save specific values selected from cascading combo boxes and entered in a text box within a subform to a destination table.

How to Save Combo Box and Text Box Values to an Access Table

Product: Microsoft Access
Device & OS: not provided
Scenario: Building a data-entry interface where a department combo box filters available articles, and the selected results must be committed to a database table.
Observed behavior: The user is seeking the best architectural approach, debating between using a VBA save button on an unbound form or utilizing bound forms and subforms.

Before you start

Ensure your database relationships are correctly established, particularly the one-to-many relationships between your primary data tables and the destination table.

Solution 1Recommended

Utilize Bound Forms and Subforms

Binding your form directly to a table is the most efficient and native way to handle data entry in Access without writing complex VBA code.

Data entry works best when one table is bound to one form. If related tables must receive records simultaneously, the standard approach is to use a main form for the 'one-side' table and subforms for the 'many-side' tables.

While you can keep cascading combo boxes as unbound controls for filtering purposes, the final data controls should be bound directly to the destination table's fields.

Set Form Record Source

Open your form in Design View, access the Property Sheet, and set the Record Source to your primary destination table.

Implement Subforms for Related Data

If you are writing to multiple tables, create a main form for the primary table and insert a subform bound to your related many-side table.

Bind Controls to Fields

Select your final combo box or text box, go to the Data tab in the Property Sheet, and set the Control Source to the specific field in your destination table.

Solution 2

Use an Unbound Form with a VBA Save Button

If your data entry process requires complex logic or validation before saving, you can use an unbound form and manually write the data using a VBA Save button.

Free Microsoft Office alternative

Looking for a Free, Lightweight Data Management Solution?

While Microsoft Access is powerful for complex relational databases, building forms and writing VBA can be overly complicated for simpler tasks. WPS Office offers a free, highly compatible alternative with WPS Spreadsheet, which allows you to manage data lists, create cascading drop-downs, and track information easily without needing database programming skills.

1. Download and Install WPS Office: Get the free suite from the official WPS website and install it on your device.
2. Open WPS Spreadsheet: Launch the application and create a new spreadsheet for your data tracking needs.
3. Set Up Data Validation: Use the Data Validation tool under the Data tab to create simple drop-down lists instead of complex Access combo boxes.

100% free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Excel formats (.xlsx, .csv, .xls)Familiar user interface ensuring seamless migration and quick adoptionEasily manage data entry with Data Validation and drop-down lists

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between bound and unbound forms in MS Access?

A bound form is directly connected to a table or query, meaning any changes made in the form automatically update the underlying data. An unbound form is not linked to a record source, requiring VBA code or macros to read and save data manually.

Can I use unbound controls on a bound form?

Yes. It is common practice to use unbound combo boxes on a bound form to act as search or filter tools (such as cascading combo boxes). Once the filtering is complete, the actual record data is saved through separate bound controls.

Why should I avoid using multi-table queries for data entry forms?

Basing a data-entry form on a multi-table query can lead to un-updateable recordsets, preventing you from adding or modifying records. It is generally best practice to bind one form to one table and use subforms to handle related records from other tables.

Office Quick Solutions