Text Box visible only when selecting specific record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in which a user will select a specifc course from a combo box.
What I am trying to accomplish is that when the user selects a specific item
from the combo box (MISC-Project), a text box will appear asking for the name
of that specifc project (Misc_Project_Name) and remain hidden when other
entries are selected. I know that this will be an After_Update event for the
combo box but I am stuck as to where I go next.... Thanks!!!
 
In the AfterUpdate event of the combo box, put logic to check what was
selected, and toggle the visibility of the text box based on that:

Private Sub MyCombo_AfterUpdate()

Me!Misc_Project_Name.Visible = (Me!MyCombo = "MISC-Project")

End Sub
 
Thanks for the info...works just fine!!!

Douglas J. Steele said:
In the AfterUpdate event of the combo box, put logic to check what was
selected, and toggle the visibility of the text box based on that:

Private Sub MyCombo_AfterUpdate()

Me!Misc_Project_Name.Visible = (Me!MyCombo = "MISC-Project")

End Sub
Click to expand...
 
Back
Top