[AccessD] Listbox Issue - Selected Property or ListIndex persisting after requery

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.



More information about the AccessD mailing list