Visible or Invisible

[andy101]

I have a large members form with several macro buttons leading to other froms which hold information about the member, i want to be able to make a button invisible depending on the value of a drop down box (values are yes or no, if the value = no the button is invisible, if the value = yes the button is visible). Please help!

 

[Pat Hartman]

The code is:
If Me.YourCombo = "no" then
Me.YourTextBox.Visible = False
Else
Me.YourTextBox.Visible = True
End If

The code needs to go in two places -
the on Current event of the form and the AfterUpdate event of the combobox.