Bill Benson
bensonforums at gmail.com
Wed Mar 12 15:44:30 CDT 2014
I have written listbox that has Table/Query RowsourceType property. I am trying to clear the selection in it by requery. It does not seem to be working. In particular, if the user has selected B out of A B C Then when I change Rowsource = "" and requery, the listbox contents vanish, but when I make the rowsource equal to what it was, the selected item is still selected. My concern about this is, what happens if B no longer exists, or the order of items changes, since I do not have a primary key type data field in the listbox. I could switch to AddItem but that might be slower. All I want to do is have nothing selected after a requery. Pulling hair out.