Listbox value property will not reset to null
Posted on 2007-03-23
What I'm doing is slightly complicated, but I'll explain as best I can. I have a listbox that's populating with a recordset based on the selection of an option frame. If a user clicks on the first item in the option frame, the list box may populate with 3 records. We'll say these records have Values 1, 2, and 3. If the user then selects the first record (with value 1), a text box populates with the information for that record. The problem comes in if the user changes the Option frame selection. If he then picks a different option, the list box may populate with a null recordset which is fine. If I run a listcount against the lsitbox, it comes back with 0 which is correct. The problem is, the Value property of the listbox is still set to 1 (or whatever the LAST value was). It will not resort back to an empty or null value. Is there any way to force this property back? Thanks!