How to reposition an item in a listbox to the top of the list?
Posted on 2012-09-11
I have a combo box that is populated with a list of items. When the user selects one of the items from the dropdown, it is inserted into a a table. A listbox displays all records in the table and is based on a query. After the combo selection, the listbox is requeried and sorted on the records that have been entered. I would like to display the most recent selection of the combo box at the top of the listbox list and leave the rest sorted. How do I move the most recently added item to the top of the listbox list? There may only be 4-6 items in the listbox but could be more. Probably not enough to scroll. I would like to see the item selected in the combo box at the top of the listbox list with the other items displayed beneath it without disturbing there sort order.