I am attempting to populate a listbox on an Access form using elements of a collection. I can populate the listbox fine using the .RowSource property of the listbox. However, I cannot select the items from the listbox. I can't even get the On_Click event.
I previously was able to get this working using the elements of a recordset. Once I switched to a collection, I was shot down.
I have the Row Source Type property set to Value List on both, Column Cout to 1 and Bound Column = 1.