Listbox .Selected=False won't work

[Ronald]

Hi.

In Access 2003 I have an unbound listbox with 2 columns. It's all standard,
no multiselect.
In the OnClick event of the listbox I use the 2 values in the columns and
then want to reset the selected row.
To do this I've tried:

Me![lstListbox].Selected(Me![lstListbox].ListIndex) = False

For Each varItem In Me![lstListbox].ItemsSelected
Me![lstListbox].Selected(varItem) = False
Next varItem

For lngRow = 0 To Me![lstListbox].ListCount - 1
Me![lstListbox].Selected(lngRow) = False
Next lngRow

but none of them work.
Why?
Please help.

Ronald.

 

[Douglas J. Steele]

Try:

Me![lstListbox].RowSource = Me![lstListbox].RowSource

 

[Ronald]

Thank you, Douglas.

No, that doesn't work (with or without my code). The selected row does flash
off and then on (selected) again.

Ronald.

Try:

Me![lstListbox].RowSource = Me![lstListbox].RowSource

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi.

In Access 2003 I have an unbound listbox with 2 columns. It's all
standard,
no multiselect.
In the OnClick event of the listbox I use the 2 values in the columns and
then want to reset the selected row.
To do this I've tried:

Me![lstListbox].Selected(Me![lstListbox].ListIndex) = False

For Each varItem In Me![lstListbox].ItemsSelected
Me![lstListbox].Selected(varItem) = False
Next varItem

For lngRow = 0 To Me![lstListbox].ListCount - 1
Me![lstListbox].Selected(lngRow) = False
Next lngRow

but none of them work.
Why?
Please help.

Ronald.

 

[Douglas J. Steele]

Sorry, I've never seen that behaviour.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thank you, Douglas.

No, that doesn't work (with or without my code). The selected row does
flash
off and then on (selected) again.

Ronald.

Try:

Me![lstListbox].RowSource = Me![lstListbox].RowSource

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi.

In Access 2003 I have an unbound listbox with 2 columns. It's all
standard,
no multiselect.
In the OnClick event of the listbox I use the 2 values in the columns
and
then want to reset the selected row.
To do this I've tried:

Me![lstListbox].Selected(Me![lstListbox].ListIndex) = False

For Each varItem In Me![lstListbox].ItemsSelected
Me![lstListbox].Selected(varItem) = False
Next varItem

For lngRow = 0 To Me![lstListbox].ListCount - 1
Me![lstListbox].Selected(lngRow) = False
Next lngRow

but none of them work.
Why?
Please help.

Ronald.

 

[Branislav Mihaljev]

Hi.

In Access 2003 I have an unbound listbox with 2 columns. It's all
standard,
no multiselect.
In the OnClick event of the listbox I use the 2 values in the columns and
then want to reset the selected row.
To do this I've tried:

Me![lstListbox].Selected(Me![lstListbox].ListIndex) = False

For Each varItem In Me![lstListbox].ItemsSelected
Me![lstListbox].Selected(varItem) = False
Next varItem

For lngRow = 0 To Me![lstListbox].ListCount - 1
Me![lstListbox].Selected(lngRow) = False
Next lngRow

but none of them work.
Why?
Please help.

Ronald.

Hi,

Technically this is the same, but try this:

Dim strList As String
With Me.listboxName
strList = .RowSource
.RowSource = vbNullString
.RowSource = strList
End With

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[Douglas J. Steele]

Don't think that works with multiselect lists, or if it does, it only works
with one type of multselect list

 

[David W. Fenton]

Try:

Me![lstListbox].RowSource = Me![lstListbox].RowSource

I thought the problem was changing the selected value? All this will
do is re-assign the RowSource, which will lose any selection.

 

[Ronald]

Thanks everyone for your help!

Ronald.