Sort a Listbox on a Form

[sumdumgai]

On a Form, there is a Listbox that is populated with records that result from a DoCmd.OpenQuery "SearchQ" when an event occurs.


One of the fields in the ListBox is 'City'. Is it possible, without re-executing the 'SearchQ' query and re-populating the ListBox, to sort the ListBox records on the 'City' field? I could add 'Sort' button or do some other event to initiate the sort but I don't know what VBA code to use. Or, is there a Requery command that I can use to sort the ListBox records on 'City'?


Thanks.

 

[CJ_London]

No, not possible - best you could do is modify the rowsource

myListbox.rowsource="SELECT * FROM SearchQ ORDER BY City"

but this will effectively re execute SearchQ - and assumes that City is the name of one of the fields returned

 

[isladogs]

Yes you can but there will be a need to re-execute in some form
First see if the info in this thread helps https://www.access-programmers.co.uk/forums/showthread.php?t=302848

If not, there are other solutions. I have something I can look up if needed

 

[sumdumgai]

Thanks islados. I went ahead and put a button on the form. The button modifies the query sql, changing the sort order. It does a rerun of the query that loads the ListBox but it works fine and doesn't take much time.