How to make combobox respond to event?

[huBBLe]

Hi,

I have a combobox with two item in it. I want to display a form depending on what is the item selected. This was what I did:

Private Sub Combo1_Change()
If Combo1.Text = "Yes" Then
Form1.Show
Form2.Hide
End Sub

Is the event used (Change) correct? This code doesn't work, can anyone help?

Thanks a million!

 

[mukund]

You should use the Click event of the Combo Box. Your code should work, if you place in the Click event.

Mukund.