Clearing combo box selection in multi select combo box

[Bob McCormack]

I want to clear previous selections in a multi-select combo box (Access 97).
I want to do that when I select a new value in a second combo box. I have an
On-Click event procedure for the second box "Me.cmbListAges.Value = Null".
It works fine if the multi-select property of cmbListAges is set to "None",
but when I set it to "Simple" or "Multi", it won't clear the selections. Any
help would be appreciated.

 

[Rick Brandt]

I want to clear previous selections in a multi-select combo box
(Access 97). I want to do that when I select a new value in a second
combo box. I have an On-Click event procedure for the second box
"Me.cmbListAges.Value = Null". It works fine if the multi-select
property of cmbListAges is set to "None", but when I set it to
"Simple" or "Multi", it won't clear the selections. Any help would
be appreciated.

Try resetting the RowSource property of the *ListBox*. You can just set it
equal to itself.

(ComboBoxes don't have a MultiSelect setting)

 

[Bob McCormack]

Oops, I meant ListBox. That worked - Thank!!

Try resetting the RowSource property of the *ListBox*. You can just set it
equal to itself.

(ComboBoxes don't have a MultiSelect setting)