>>>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.
>
>How do I reset the value? I was using this.value to give me the listbox "recordnumber" which I need to make use of.
thisform.ListBox.Value = []
thisform.ListBox.RowSource = [Something]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.