Others

Automatically Populate an Email Field from an Access Combo Box

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

Automatically display an employee's email address when the employee is selected from a form's drop-down list.

Automatically Populate an Email Field from an Access Combo Box
Product
Microsoft Access
Device & OS
not provided
Scenario
An Access form uses a combo box to select an employee whose name and email may be stored in one or more related tables.
Observed behavior
The desired result is for the email field to show the address associated with the selected employee.
Before you start

Identify the combo box name and the tables and fields containing the employee ID, name, and email address. If the data is in separate tables, identify the matching key fields used to join them.

Solution 1Recommended

Display the Email Address from a Combo Box Column

Use this method to show the selected employee's email without storing a separate copy in the form's underlying record.

1
Open the form in Design View

In the Navigation Pane, right-click the form and select Design View. Select the employee combo box and open its Property Sheet.

2
Set the combo box Row Source

On the Data tab of the Property Sheet, set Row Source to a query containing the employee ID, name, and email, in that order. For example: SELECT [ID], [Employee Name], [E-Mail Address] FROM [Employees Extended] ORDER BY [Employee Name]; Replace the table and field names with your own.

3
Configure the combo box columns

On the Format tab, set Column Count to 3 and Column Widths to 0;1.5;0 to display the name while hiding the ID and email. On the Data tab, set Bound Column to 1 if the form should store the employee ID.

4
Add the email expression

Add a text box to the form or select the existing email display box. In its Property Sheet, set Control Source to =[cboEmployee].Column(2), replacing cboEmployee with the combo box's actual Name property.

5
Test the selection

Save the form, switch to Form View, and select an employee from the combo box. Confirm that the text box displays the matching email address.

Display the Email Address from a Combo Box Column
Column numbers start at zero: Column(2) refers to the third column in the Row Source. The calculated text box displays the email but does not save it as a separate field.
Free Microsoft Office alternative

Work with Employee Lists in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday documents and spreadsheets, with a familiar interface and support for Microsoft Office formats. Move compatible employee lists into WPS Spreadsheets for viewing and editing; it does not replace Microsoft Access forms or fix their combo boxes.

View and edit employee lists in a spreadsheetCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the expression use Column(2) for the email address?

Access combo box column indexes start at zero, so Column(2) refers to the third column. Check the order of fields in the combo box's Row Source if the email is in a different position.

How can I show only the employee name in the drop-down list?

In the combo box Property Sheet, set Column Count to 3 and Column Widths to 0;1.5;0. This hides the first and third columns while displaying the name in the second.

Can the employee name and email come from different tables?

Yes. Open the combo box's Row Source query builder, add both tables, and join their matching employee key fields. Include the ID, name, and email in the query.

Does the calculated email text box save the address?

No. A text box whose Control Source is an expression such as =[cboEmployee].Column(2) displays the selected value but does not store a separate copy of it.