Sort in List box - Click to Sort by Column in Microsoft Access


	Back to Click to Sort Comments List

Upload Images @Reply Bookmark Link Email

Sort in List box

Juan C Rivera

3 years ago

I follow the video and it works great. But me I have to try other things. LOL I did a list box with click and open form. So I say to my self what if this list gets to long and I like to sort it (I have 3 fields). Lets say ID, LastName, State. ListBox is named ContactListBox. How can I address the fields in the list box to sort from a Label on the form? Any takers out there?

V/r
Juan

	Scott Axton @Reply 3 years ago
Juan - You just need to change the SQL for the order by property. Now if you are saying you want to accumulate the sorts as you click the labels - different issue. Take a look at the Search Form 2.0 for how to add on to your search / sort.

	Juan C Rivera OP @Reply 3 years ago
Thanks Scott Ill take a look.

	Richard Rost @Reply 3 years ago
Basically `ListBoxName.RowSource = "SELECT ID, LastName, State FROM WhateverT WHERE State=""" & StateFilter & """"` I've got a new Search Template coming out very soon that is basically a scaled down version of the Search Seminar, and will show how to do this. Stay tuned.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Click to Sort.