LISTBOX, NOT GRID!
Access 2010 Desktop
this is very weird (and urgent).
when i select rows in a ListBox control on a form, using access vba, some rows behave exactly the opposite of how they're supposed to behave-- they APPEAR unselected when i select them, and selected when i unselect them.
Code:
oListBox.Selected(lngRow) = True
However, when i check their Selected property with VBA they return the expected value (meaning the row Selected value is TRUE if i set it to TRUE, if tho it LOOKS UNselected).
Code:
Print oListBox.Selected(lngRow)
->True
video:
youtu.be/Ae0adXdmT48
It seems that the more times i requery the listbox, the worse the problem gets.
This problem seems unrelated to the number of times i select rows. Only seems related to multiple requeries. At first, it does not happen. Then with repeated requeries, the problem gets progressively worse.
Note, 'Row Source Type' is set to 'Table/Query'. 'Multiselect' is set to 'Simple'.
i'm not using the "Form_" syntax anyplace (which can created unintended instances of forms).
not sure if relevant, but this listbox source-query contains a vba function in a module, which in turn calls the code-behind of another form.
help!
note, i may post this question on other MS Access forums, so plz only answer in one place. thx!
ListBox-Rows Not Displaying Selected-State Correctly After Many VBA Requeries
