How do you clear contents of a combo box so it can have diferent items. This is the scenario:

I have two combo boxes. The selection in the first combo box will determine what items will be displayed in the second combo box. What is happening is, everytime I change the selection of the first combo box, the second combo box will get appended with items even though the items getting appended are already there.

Basically, I just want the second combo box to be cleared then populated everytime I make a selection in the first combo box.

Thanks,
Judy

Dim lngCount as long

For lngCount = 0 To ComboBox1.listCount - 1
      ComboBox1.RemoveItem(0)
Next

Could you explain yourself a little better?

... append .. even though the items already there ...?

... populated whenever they select an item from combo box 1 ...?

If the item is already there why do you want to append it?

If you clear the combobox2 each time a selection is made in combobox1 what do you want to populate it with, the item selected from combobox1?

You can clear a combobox using the clear method: combobox.clear

You don't need to loop through each item.

If you could give us a bit more information.


Larry Asher

Hi Larry,

Yehuda's code worked perfect. Thanks Yehuda.

When I select an item from the first combo box, the second combo box should be populated with items related to the first combo box selection. Ex:

First Combo Box selections :
1)Section A
  items under Section A to show in 2nd Combo Box :
      a) CEO
      b) Manager
      c) Supervisor
2)Section B
   items under Section B to show in 2nd Combo Box :
      a) Vendor
      b) Marketing Rep
      c) Employee


Second Combo box :

If Section A is selected in the first combo box then it should only have CEO, Manager & supervisor displayed in the second combo box.
If Section B is selected in the first combo box then it should only have Contractor, Vendor & Employee displayed.

Now...I chose section A then section B. What I have in the 2nd combo box now are both items from section A & B when it should only show items from Section B since it was the last selection from the 1st combo box.

The idea is to just display the items related to the 1st combo box.
I hope this was a little helpful.

If it still does not explain my problem better, then look at Yehuda's reply and the code used was the answer to this question.

Thanks,
Judy

I found out that you can also accomplish the same task by issuing the ADO command clear.

Combo1.clear

Thanks,
Judy

Actually, you don't have to clear the second combo box at all. All you have to do is reset its rowsource depending on the selection of the first combo box.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yehuda, this isn't working for me. I am unable to chnage my mind after i make a selection in the first combo box (unless I close the form and start over). Here is my code (mega is first combo, major is second based on the choice of Mega)

--------------------------------------------
Private Sub cbMega_Name_Click()
Dim lngCount As Long

For lngCount = 0 To cbMega_Name.ListCount - 1
        cbMega_Name.RemoveItem (0)
Next

End Sub

---------------------------------------
my e-mail:
-----------------------------

well... in a loop of this type you should use the index to get each value.

this:
Should actually be this:
However... the typical way to do this is as suggested previously:
ComboBox1.Clear

Woody Z http://www.learntoprogramnow.com

Where do I type this in my form? I don't know anything about coding and very little about Access, so please please be specific.