Create a New Record Source

For the Customer Combo Box

1. Use a Query for the Record Source

A Select Query can combine the phone number and the customer name. When someone types in the number, they will get the customer's name, too.

 

Try it: Create a Select Query

Go to Create-> Query Design

 

Show/Table: Select tblCustomer

Add the CustomerID Field to the QBE grid.