Clear list box selection

[Opal]

In Access 2003, how can I clear
the selection from a list box in an
unbound form?

I tried:

LstTM.ListIndex = -1

but I get an error telling me:

'You've used the ListIndex property incorrectly"

 

[Douglas J. Steele]

It depends on whether you've got MultiSelect enabled (and what type of
MultiSelect if you do), but try

LstTM = Null

 

[Opal]

Hi Doug,

I set the box to "Simple" multi-select

and

LstTM = Null

does not work

:-(

 

[Douglas J. Steele]

In that case, try:

LstTM.RowSource = LstTM.RowSource


LstTM = Null will work if MultiSelect is None or Extended.

LstTM.RowSource = LstTM.RowSource will work if MultiSelect is Simple or
Extended.

 

[Opal]

Thank you Doug, I will give it a try on Monday
when I get back into work.