Combo Box sort problem

[Jim]

In Access 2002 I have a combo box tied to a basic table to the Surname
field. The Surname field is set to order by Surname and the Table is indeed
sorted right.
But in the Combo box on the form the dropdown shows the Surnames are all
over the place.
I can't see how I can sort the dropdown alphabetically from the Combo box
properties.
The row source is set as:
SELECT [Names&Addresses].[Surname], [Names&Addresses].[Title] FROM
[Names&Addresses]
Help please!!
Jim

 

[Cheryl Fischer]

You still have to tell your query how it is to be sorted, so add an Order By
clause to your query:

SELECT [Names&Addresses].[Surname], [Names&Addresses].[Title] FROM
[Names&Addresses] ORDER BY [Surname]

 

[Jim]

Hi Cheryl
Thats it!!
I didn't think that the row source could be modified!!
Many thanks
Jim

You still have to tell your query how it is to be sorted, so add an Order By
clause to your query:

SELECT [Names&Addresses].[Surname], [Names&Addresses].[Title] FROM
[Names&Addresses] ORDER BY [Surname]


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

In Access 2002 I have a combo box tied to a basic table to the Surname
field. The Surname field is set to order by Surname and the Table is indeed
sorted right.
But in the Combo box on the form the dropdown shows the Surnames are all
over the place.
I can't see how I can sort the dropdown alphabetically from the Combo box
properties.
The row source is set as:
SELECT [Names&Addresses].[Surname], [Names&Addresses].[Title] FROM
[Names&Addresses]
Help please!!
Jim