Combo box auto drop down

Hi Folks
I want to get a combo box to drop down, displaying its list when I make a selection from another combo box.
Anyone know how?

Cheers
ML

Put this in the General Declarations area of the form: (The area above the rest of the code)

Code:

---

Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Private Const CB_SHOWDROPDOWN = &H14F

---

And put this into the Click event of the ComboBox you want to make the selection from:
SendMessage Combo2.hwnd, CB_SHOWDROPDOWN, 1, 0&

..And change Combo2 to the name of the combobox you want the list to drop down for.

Thanks for helping me again Tygur