Combo box auto drop down

[mick lennon]

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

[Tygur]

Put this in the General Declarations area of the form: (The area above the rest of the 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.

[mick lennon]

Thanks for helping me again Tygur