List Box Wont Sort

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

I have a table with values and the table is sorted Ascending. I then have a
form with a list box and it pulls it values from this table. The values in
the list box on the form wont sort yet they are definitely sorted in the
table. How can I get the list box to sort the way I have it in the table it
is getting its vaoues from?
 
ibeetb said:
I have a table with values and the table is sorted Ascending. I then have a
form with a list box and it pulls it values from this table. The values in
the list box on the form wont sort yet they are definitely sorted in the
table. How can I get the list box to sort the way I have it in the table it
is getting its vaoues from?
Click to expand...

Use a query instead of the table to fill your list. In the query, set
the sort you want.
 
I have a table with values and the table is sorted Ascending. I then have a
form with a list box and it pulls it values from this table. The values in
the list box on the form wont sort yet they are definitely sorted in the
table. How can I get the list box to sort the way I have it in the table it
is getting its vaoues from?
Click to expand...

Create a query using the table.
Sort the query.
Then set the Rowsource of the list box to that query.
 
Back
Top