Trying to Hide/Display Fields based on checkbox being selected

[Ben Pelech]

Hello, I am trying to see if I can show/hide about 5 combo boxes based on
whether a check box is displayed. Right now, the code I found so far, only
allows me to Show them if the check box is selected but will not hide them if
it is unselected. Below is the current code

Private Sub Was_Contact_due_to_Error__Click()
Me.Combobox1.Visible = True
Me.ComboBox2.Visible = True
Me.ComboBox3.Visible = True
Me.ComboBox4.Visible = True
Me.ComboBox5.Visible = True
End Sub

I would also like a way to add in the code to add new form that will refresh
these combo boxes on the new form if the previous was selected. It doesnt
seem to completely refresh if there was an error on the previous form and the
check box was selected.

Any help would be greatly appreciated

Thanks

 

[Marshall Barton]

Hello, I am trying to see if I can show/hide about 5 combo boxes based on
whether a check box is displayed. Right now, the code I found so far, only
allows me to Show them if the check box is selected but will not hide them if
it is unselected. Below is the current code

Private Sub Was_Contact_due_to_Error__Click()
Me.Combobox1.Visible = True
Me.ComboBox2.Visible = True
Me.ComboBox3.Visible = True
Me.ComboBox4.Visible = True
Me.ComboBox5.Visible = True
End Sub

Private Sub Was_Contact_due_to_Error__Click()
Me.Combobox1.Visible = Me.Was_Contact_due_to_Error_
Me.ComboBox2.Visible = Me.Was_Contact_due_to_Error_
Me.ComboBox3.Visible = Me.Was_Contact_due_to_Error_
Me.ComboBox4.Visible = Me.Was_Contact_due_to_Error_
Me.ComboBox5.Visible = Me.Was_Contact_due_to_Error_
End Sub

I would also like a way to add in the code to add new form that will refresh
these combo boxes on the new form if the previous was selected. It doesnt
seem to completely refresh if there was an error on the previous form and the
check box was selected.

I don't understand what you are trying to do here.

 

[Ben Pelech]

I have a database that I have a checkbox that indicates an error is made. I
have 5 combo boxes that i would like to hide and display based on if the
checkbox is checked. For example. There was an error made, the 5 combo
boxes appear that you choose which kind of error it was. But i dont want
them visible if there is no error.

Is this possible?

Thanks

 

[Marshall Barton]

You said that before.

Did you try the code I posted? If you did, what happened?
If you don't try it, why not?

 

[Ben Pelech]

Sorry I was confused. Did not realize what you put in my original post. It
works perfectly for the check/uncheck to hide/unhide the combo boxes. My
only problem now is that when i go to a new form (click add new command
button) the combo boxes appear on the new form instead of refreshing as a
clean entry.

Thanks for all of your help!!!

You said that before.

Did you try the code I posted? If you did, what happened?
If you don't try it, why not?
--
Marsh
MVP [MS Access]

I have a database that I have a checkbox that indicates an error is made. I
have 5 combo boxes that i would like to hide and display based on if the
checkbox is checked. For example. There was an error made, the 5 combo
boxes appear that you choose which kind of error it was. But i dont want
them visible if there is no error.

 

[Marshall Barton]

Try this in the form's Current event procedure:

If Me.NewRecord Then
Me.Combobox1.Visible = False
Me.ComboBox2.Visible = False
Me.ComboBox3.Visible = False
Me.ComboBox4.Visible = False
Me.ComboBox5.Visible = False
End If

 

[Ben Pelech]

Thank you so much! It works perfectly!!!!!

Try this in the form's Current event procedure:

If Me.NewRecord Then
Me.Combobox1.Visible = False
Me.ComboBox2.Visible = False
Me.ComboBox3.Visible = False
Me.ComboBox4.Visible = False
Me.ComboBox5.Visible = False
End If
--
Marsh
MVP [MS Access]

Sorry I was confused. Did not realize what you put in my original post. It
works perfectly for the check/uncheck to hide/unhide the combo boxes. My
only problem now is that when i go to a new form (click add new command
button) the combo boxes appear on the new form instead of refreshing as a
clean entry.