>When I chg the rowsource in a listbox, "this.value" proves to be null but gave a legit nbr b4 I chg the rowsource.
>How could I get around this?
ListBox has a value, it doesn't have DisplayValue :-)
Where you change RowSource there you must reset Value also.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.