Reset Listbox to Null???

[Jen123]

Hi,

I have a listbox and I want to use the "on double click" to run some code. This is working fine but I can't seem to reset the list box to null when I have selected the first value as I want to run different code, if a value isn't selected. Can this be done?

Cheers

 

[Trendsetter]

Have you tried running a requery on the listbox?

Me.lstWhatsItsName.Requery

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[Jen123]

Yes - certainly have. No luck

I've also tried resetting the .value, and .selected to no avail.

 

[Trendsetter]

The code for selecting an item in a listbox is:

Me(ListBoxName).Selected() - I would think there would be someway of deselecting using this.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[kire1971]

I had the same problem and the following worked for me...

Dim i As Integer
For i = 0 To ListBoxName.ListCount - 1
ListBoxName.Selected(i) = False
Next i

 

[Jen123]

Cheers for this.... I eventually got it working with this

lstboxName.Value = Null