Clearing combo box selection in multi select combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Bob said:
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.
Click to expand...

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

(ComboBoxes don't have a MultiSelect setting)
 
Oops, I meant ListBox. That worked - Thank!!

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

(ComboBoxes don't have a MultiSelect setting)
Click to expand...
 
Back
Top