Showing Texbox depending on combo choice
Hi all
I have a form with different info choices in a combo list
NO
Green
Yellow
Red
etc
Ideally what happens is the user fills out the info in a form and selects the appropriate info from the combo box they then click a button and then goes to a report in the correct format, my question is if a user selects "NO" I want a certain textbox to not show in the report but any other colour then it can is this possible?
This is my code so far but struggling to get it to work
Hi all
I have a form with different info choices in a combo list
NO
Green
Yellow
Red
etc
Ideally what happens is the user fills out the info in a form and selects the appropriate info from the combo box they then click a button and then goes to a report in the correct format, my question is if a user selects "NO" I want a certain textbox to not show in the report but any other colour then it can is this possible?
This is my code so far but struggling to get it to work
Private Sub ComboListColour_Enter()
If Me.ComboListColour = "NO" Then
Me.TextBoxColour.Visible = False
Else
Me.Text44.Visible = True
End If
End Sub
Last edited: