Refresh a listbox

[Robert_DubYa]

I have a list box where the data from the table that populates the list box
is deleted. It is re-populated later on. How do I refresh the data in the
listbox? It currently just says "Deleted". I want the new values to appear
in the listbox.

thanks,
Robert

 

[Gina Whipp]

Robert,

Something like...

Me.ListBox.Requery

....in the Event of the button that deletes the data.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a list box where the data from the table that populates the list box
is deleted. It is re-populated later on. How do I refresh the data in the
listbox? It currently just says "Deleted". I want the new values to appear
in the listbox.

thanks,
Robert