Combobox problem?

[Tainc]

I'm trying to set properties for what happens when I select an item from a combobox. Right now I have it set up like this:

dadada
Private Sub cmbLenstype_Change()
 If cmbLenstype.Text = "Bitoric" Then
   txtItemcode.Show
 End If
End Sub

But it doesn't work. I'm trying to make a textbox appear as soon as the option 'Bitoric' is selected in the combobox.
Please help!

You can probably tell I'm new at this by the elementary level of my past few posts. ^_^

thx,
tainc

[Tainc]

Just realized I forgot to get rid of the 'dadada'.
It's not part of the code. Pls ignore.

thx!

[reeset]

Instead of using the Combo_Change event, use the Combo_click, and then use something like this:

Private Sub Combo1_Click()
If Combo1.List(Combo1.ListIndex) = "Text1" Then
    Form2.Show
End If

End Sub

[ttingen]

The change event fires when text is typed into the combobox. The click event fires when you choose an item from the list.

[Tainc]

Oh, I get it. Thanks for the clarification!

-tainc

[Tainc]

Anyone have any ideas for getting the information into an email, like I described? Or know a place with a tutorial that might cover it?