Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Paeroa, New Zealand
    Posts
    16

    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!!

  2. #2
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    me.listbox1.rowsource = ""

    thats one way of doing it...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •