To display additional information by using a Combo Box or List Box control, set the properties of the control this way:
Include the fields to be displayed in the Row Source property.
Set the Column Count property to reflect the total number of columns you want to include.
Set the Column Widths property to 0 to hide the extra columns.
You can then create calculated fields and set the Control Source property of them to the column of the Combo Box or List Box control you
desire to display. The form below displays the phone number of the client beside the combo box when a client is chosen.
The calculated field next to the combo box, called txtPhone, has its Control Source property set to
cboClient is the name of the Combo Box control.
Column(2) is the third column over (starting from 0).