Combobox2.Clear will remove all of the items. Not a good idea.

When you say 2 is dependant on 1, do you men that if you select item 10 in
1, then item 10 in 2 should be shown, if so, then use something like

Combobox2.ListIndex = Combobox1.ListIndex

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Shilps" wrote in message
...
Hi,
I have a list of three combo boxes. The entry in the second depends on the
entry in first, same for the second.
Before the entries are filled, I have used Combobox2.Clear and
Combox3.Clear.

The problem arises when I try to select the option from the drop down list
again. These two statements are supposed to be executed. Although
Combox2.Clear runs, the progran gives an error on ComboBox3.Clear.
Any idea why? and what to do to avoid it?
TIH
Shilps