Text Box appearing after Combo box selection is made

[Adam D]

So I am fairly new to Access. I am creating a form and one of the fields is a combo box that displays a list of selections. When the person selects the other option, I want a text box to appear below so they can enter additional information. I have heard that you need to add code to the after update event, but I am not sure what the code should be. Any ideas?

[Mihail]

What mean "other option" ?
One of the row in your combo box is "other" or you type a new option that is not listed in the combo box rows ?

[pdebaets]

Put this code in the combo box AfterUpdate event procedure:

MyTextBoxControl.visible = True

... where "MyTextBoxControl" is the name of your text box.

[tuxalot]

And to get this to fire when a user selects "other", try something like this:

    If cboName.Column(1) = "Other" Then
        MyTextBoxControl.Visible = True
    End If

[NeoPa]

@Adam I was able to work out what the question should have been by reading some of the posted answers.

NB. Similarly vague and unclear questions are likely to be deleted in future.

As a solution though, you may want some code similar to :

Private Sub MyComboBox_AfterUpdate()
    Me.MyTextBox.Visible = (Me.MyComboBox = "Other")
End Sub