I have a list box and a sub form having Table as their record source. The user can select items in the list box and click of a button adds the selected items to the sub-form and it works perfectly. If the selected item is at the bottom of the list box then that row of the list box is still highlighted, though that item has been removed from the list box. I requery the list box after removing the selected items but the blue coloured strip at that row still shows. The problem is only the appearance of the list box after removal of item. I got around the problem by resetting the row source of listbox in code.
Code:
strSQL2 = Me.lstItems.RowSource
Me.lstItems.RowSource = ""
Me.lstItems.RowSource = strSQL2
Me.lstItems.Requery
Is there any other way ?