Unanswered: Clearing a Listbox based on a ValueList
I need help here!! I have looked everywhare for the VBA code to clear my listbox of all values in the valuelist, and cant find anyting that does the trick. The listbox in question is based on a ValueList Type, adn is populated by a loop ruitine that looks up values in a recordset. When I press a button on my vorm (that opens a dialog box so I can select the file I want for the listbox lookup) the listbox adds the itmes in the new file to the listbox, but does not clear the old values.
Can someone tell me how to get the listbox to clear all values, before adding the next lot of items to the valuelist?
Though the eyes may falter, the heart strives to fill the gap. A strong heart leads to patience and persistance... Dont count such a visionary out for success!!