Automatically Populate an Email Field from an Access Combo Box
Question details
Automatically display an employee's email address when the employee is selected from a form's drop-down list.

- 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.
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.
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.
In the Navigation Pane, right-click the form and select Design View. Select the employee combo box and open its Property Sheet.
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.
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.
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.
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.

Join Related Employee Tables in the Combo Box Query
Use a joined query when the employee name and email are stored in separate related tables.
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.

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.




