I have a Combobox wish I named NamePrefixcombo. The Combo box Is a list of Name prefix like Mr,Miss,Mrs. My question Is can I make something disappear If the combo Box equal Mr.? I know How to do that If I use a Yes/No field but I don't know If you can do It with a combo Box?
I put the NamePrefixID,NamePrefix. So the Id you don't see and the NamePrefix you see and I name the Combobox NamePrifixCombo.
William DeGrandisOP
@Reply 2 years ago
I tried MsgBox NamePrefixCombo and It comes back as a number 1. so I tried IF nameprefixcombo = 1 then firstName.visible and that didn't work. I am tring to figure it out myself too.
Kevin Robertson
@Reply 2 years ago
Here's a couple of ways.
The ID (First Column):
If NamePrefixCombo = 1 Then
FirstName.Visible = True
Else
FirstName.Visible = False
End If
The Visible Column (Second Column):
If NamePrefixCombo.Column(1) = "Mr" Then
FirstName.Visible = True
Else
FirstName.Visible = False
End If
William DeGrandisOP
@Reply 2 years ago
Thank you. I also got this to work Age.Visible = NamePrefixCombo = 1
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visible.
