Deselect an entry in a list box

[dubmunkey]

hi all,

ive ste up a form with list boxes being used as filters but once ive made a selection i can deselect it to clear the filter. any ideas where the stetings are to control this?

greg

 

[ansentry]

For single select List Box:

Me.[COLOR="Blue"]lstYourListName[/COLOR] = ""

For Multi-Select Box

Dim i As Long
For i = 0 To Me.[COLOR="Blue"]lstYourListName[/COLOR].ListCount - 1
    Me.[COLOR="Blue"]lstYourListName[/COLOR].Selected(i) = False
Next i

Change lstYourListName to suit

 

[dubmunkey]

cheers

greg

 

[dubmunkey]

cheers
greg