Sorting Combo Box list

B

babyatx13 via AccessMonster.com

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

Thanks.

Phil
Click to expand...


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
 
P

Phil

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
 
B

babyatx13 via AccessMonster.com

Phil said:
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.
Click to expand...
Click to expand...


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
 
F

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
Click to expand...

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.
 
P

Phil

Thanks guys. It works.

Phil

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