Combo Box sort problem

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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]
 
Hi Cheryl
Thats it!!
I didn't think that the row source could be modified!!
Many thanks
Jim


Cheryl Fischer said:
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

Jim said:
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
Click to expand...
Click to expand...
 
Back
Top