Deleting and Item from a listbox.

[Insentive]

I am seriously stuck on how to delete an item form a list box, Basically i want on the click of a button for selected item to be deleted from the list box. My first thought just simply do .removeitem then .itemselected but obviously that didnt, what was i thinking, Can anyone help me out here?

 

[RuralGuy]

What is the RowSourceType and the RowSource?

 

[Insentive]

RowSource is a query and therefore the rowsource type would be table/query.

 

[RuralGuy]

Then a delete query and requerying the ListBox should solve your problem, right?

 

[gemma-the-husky]

you cant just remove items from a listbox- you have to think in terms of designing the query in such a way that it will only select the items you want to see.

hence you need to process the selection in some way, and then requery the list box