Removing data from a list box

[Figzus]

How do you delete data that is in a listbox populated from a database? The once you delete it from the database how do you remove it from the listbox itself? Thanks

 

[rstitzel]

Are you talking about an Access listbox? If so, I believe if you go into the PROPERTIES of the list box and remove the information under ROW SOURCE that will clear the values that are being listed.

 

[TonyJollans]

Hi Figzus,

It depends how you put it in the listbox in the first place - (assuming Access) is it a query or a value list? - is it dynamically filled in code?. Can you give some more details please?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Figzus]

Sorry I was out for a few days. These values that fill the listbox are from a query. It fills the listbox based on an ArtID. So when you go to edit an article and it available paths you should be able to delete the paths from the listbox and the database as you see fit. Hope that gives you enough information.