DataCombo

[RayA]

I have a datacombo whose data source is adodc (access 2000). The two items in the table are employee name and employee number with the key being the employee name. When I open the form and the data combo loads it lists the employee name in emp number order.

I need the bound text to be the employee number, but, I want the displayed text to be the employee name so that a user can key the name and scroll down.

What controls how it displays.

Thanks in advance.

[d.paulson]

Just set the Listfield property

David Paulson

[RayA]

The list field property is the correct data. I went to the access table and changed the spelling of my last name and the change reflected in the combo box. The combo box is displaying the correct data (the emp name) but in emp number order which is not how the table is set up.

Thanks in advance

[Iouri]

In adodc RecordSource instead of the table name enter the SQl
select * from Table order by empnumber

Iouri Boutchkine
[email protected]