Clearing a List box

[access83]

Hi All,

I'm trying to clear the contents of a listbox but not having any success. The Row Source Type is 'Table/Query'. I've tried..

Me.ListBox_Name.RowSource = ""
Me.ListBox_Name.RemoveItem(1)

The source of the Listbox is the result from a Stored Procedure in SQL Server..

Forms!frm_ViewRequests.list_details.Recordset = rsPerformSearch

list_details is the listbox, rsPerformSearch is the recordset. The records returned from the Stored Procedure are in rsPerformSearch.

Does anyone know how to clear the listbox?

Thanks in advance

 

[pr2-eugin]

I have used the
Me.ListBox_Name.RowSource = "" and it does the trick, not sure why it is not working out for you.