How do you clear a listbox

[Wilb]

The normal VB clear method doesn't work in Access 2000

 

[spacepro]

Hi,

To empty the listbox, set the rowsource to nothing, i.e.

me.listboxname.rowsource = ""

To enable the entries reset the rowsource to the original sql statement.


Hope this Helps

Andy