Access 2003 - Combobox issue on form

[sendtobrad]

I have a combo box for Pilot which uses qry.pilot for the rowsource. This query has two columns. The first is star_no which is unique for each pilot. The second is Pilot: [tblPilots].[Title] & " " & [tblPilots].[F_Name] & " " & [tblPilots].[L_Name] & " " & [tblPilots].[Emp_cell]. When you select the combo box on the form you see TX-X1609\AIA Brad Qualls 337-499-8512 and when you select it only puts TX-X1609 on the form. I would like it to only store TX-X1609 in the field Pilot on the underlying table but want to see all of the information on the form. How can I make this happen?

 

[pbaldy]

Try a textbox with a control source of:

=ComboName.Column(1)