Combo box display

[Gavx]

On a form I have a combo box with the following details;

Control source = Customer ID
Column Count = 2
Column Width = 0;4
Row Source = SELECT Customer.CustomerID, [Surname] & ", " & [FirstName] AS CustomerName FROM Customer ORDER BY [Surname] & ", " & [FirstName];
Bound Column =1

When I click on the drop down arrow it displays the 2 columns - perfect. But when I select the record is displays the CustomerID whereas I want it to display the CustomerName as returned by the Row Source SQL statement.

Can this be done?
thanks

 

[JHB]

Change the property "Bound column" to 2.