Getting ListBox items into a variable in VBA
Posted on 2011-05-05
I have a form that has a ListBox (called “Article”, and with no Control Source) containing only 4 items that I have typed in.
When the user selects on of these items I want the selected item to be assigned to a string value in my VBA.
I have tried using [Article] and Article.value each of which always contain NULL regardless of what value actually shows in the ListBox.
I have also tried to include a ‘Control Source’ (to a field called [Article]) which always loads the associated table with only the first item from the ListBox.