the item in list box highlight?

[vicgirl]

the item in list box selection?

Hi everyone,
I have added "Move up"/"Move down" button for the list box in my form. However, when I select an item in the list and click "Move up"/"Move down" button, the item below/above the selected item is selected. How do I set the original item selected? Attached is the copy of the db

Thanks in advance!

vicgirl

 

[vicgirl]

Also I have tried to add

Me!List0.SetFocus

SendKeys "%{Down}"

But it doesn't work. It still selects the same item. The highlight doesn't move down.

 

[dt01pqt]

Quite simple use the Listindex property of listbox to select the item you want. You need to put the Listindex into an integer or long dim and after you resort the list set the Listindex by the ListIndexDim +/- 1. The listbox has to be in focus before you use this property.