Sorting Combo Box list

[Guest]

How can I sort the information displayed in the Combo Box list?

Thanks.

Phil

 

[babyatx13 via AccessMonster.com]

How can I sort the information displayed in the Combo Box list?

Thanks.

Phil

In the table where the list is click on what field you want to sort by and
click the AZ or ZA.
or
In the query select Ascending or Descending in the "Sort:" box on which ever
field you want to sort by.

K Board

 

[fredg]

How can I sort the information displayed in the Combo Box list?

Thanks.

Phil

Use a query as the combo box rowsource.
Sort the query however you wish.

 

[Guest]

Sorry, I don't see it. The Row Source Type was already Table/Query. Is this
the same as Query? And where/how do I sort it. (I can do that with a query,
but I'm working with a form.)

Thanks.

Phil

 

[babyatx13 via AccessMonster.com]

Sorry, I don't see it. The Row Source Type was already Table/Query. Is this
the same as Query? And where/how do I sort it. (I can do that with a query,
but I'm working with a form.)

Thanks.

Phil
[quoted text clipped - 4 lines]

Use a query as the combo box rowsource.
Sort the query however you wish.

Assuming your list is in a table, write a query for the list you want to be
displayed in your combo box, name it something you will recognize as being
for that particular list and in Properties, Row Source, select that query
from the list contained in the drop down arrow.

While making your query from the table where your list is sort on what ever
field you want.

K Board

 

[fredg]

Sorry, I don't see it. The Row Source Type was already Table/Query. Is this
the same as Query? And where/how do I sort it. (I can do that with a query,
but I'm working with a form.)

Thanks.

Phil

That's fine. The RowSourceType is supposed to be Table/Query.
It's the RowSource you have to change.
Click on the RowSource property line.
Click on the button with the 3 dots on that line.
If your RowSource is already a query the query grid will appear. On
the column that you wish to sort on, set the Sort row of that column
to either Ascending or Descending.
Save the changes.

If the RowSource is a Table, then after you click on the 3 dot button,
create a query (when prompted) and sort the query as I've mentioned
above.
Save the changes.

 

[Guest]

Thanks guys. It works.

Phil

That's fine. The RowSourceType is supposed to be Table/Query.
It's the RowSource you have to change.
Click on the RowSource property line.
Click on the button with the 3 dots on that line.
If your RowSource is already a query the query grid will appear. On
the column that you wish to sort on, set the Sort row of that column
to either Ascending or Descending.
Save the changes.

If the RowSource is a Table, then after you click on the 3 dot button,
create a query (when prompted) and sort the query as I've mentioned
above.
Save the changes.