combobox issue

[rexb]

I have a combo box which is displaying option1, option2, option3 etc. I need to display another field when i choose say option2.

How do i do these? Help please.

 

[Rabbie]

I have a combo box which is displaying option1, option2, option3 etc. I need to display another field when i choose say option2.

How do i do these? Help please.

where do you want to display the second field?

 

[rexb]

I think the right question would be "how to make text field visible based on combo box selection?"

 

[OMS]

I think what your looking for is along the lines of

If Combobox = Option1 Then
  Textbox1.Visible = True
ElseIf Combobox = Option2 Then
  Textbox2.Visible = True
ElseIf Combobox = Option3 Then
  Textbox3.Visible = True
End If

Replace Combobox with the name of your Combobox and replace Option1,Option2 etc with what is in your combobox.

also replace textbox with the name of the textbox1,textbox2 etc with the name of the text box.

Then place the code in the After Update of the Combobox.

Hope this helps.

OMS

 

[rexb]

Thanks OMS I was able to make it work base on your recommendation