Is it possible to sort list box? (1 Viewer)

[mraccess101]

I have created a list box, but is by default sorted by the first column. I would like to sort the list based on other column.

I also would like to have the headers of the tables in the list box. I don't also know if this is possible, if so, please explain me how to get a header in a list box.

PS
I'm do not have much experience in Access and I also don't have any knowledge of SQL, so please explain me how to do it through the User Interface of Access, if possible.

Thanks in advance.

 

[R. Hicks]

I assume that the list box uses a query for the row source ..
If you are using a table for the row source .. then create a query for this instead ...
Then you can sort the query any way you wish.

R.

 

[mraccess101]

I assume that the list box uses a query for the row source ..
If you are using a table for the row source .. then create a query for this instead ...
Then you can sort the query any way you wish.

R.

I made a form based on a table which is easier for me to edit the tables. The reason why I made a list box based on the same table of the form is to find quick the record I am searching for. So if I made query, then the listbox would not correspond with the form.

 

[R. Hicks]

So if I made query, then the listbox would not correspond with the form.

That makes no sense to me ...
The query would only alter the sorting .. as it seems that you are asking here.
Also .. the form could just as easily be bound to a query as it would be to a table ...
In most cases .. it's preferred that a query be used for the Recordsource ...

R.