I have been searching all over for a solution to this, and thought cascading comboboxes was the answer to my issue however it does not work how I would like for it to. Let me first explain what I am looking to do.
I have a combobox "Treatment1" you must select a treatment from the drop down, only after this field is populated, would I like for combobox "Treatment2" to be displayed, and so forth. I was able to hide the field by inserting the following code into my form as well as combobox however I cannot get it to display itself once an option for "Treatment1" is chosen.
Here is an example of my code:
Private Sub Form_Load()
'This code will hide the named text box until a selection has been made in your Combo, assuming that it does not have a default value
If IsNull(Me.ComboTreatment1) Then
Me.ComboTreatment1.Visible = False
Else
Me.ComboTreatment2.Visible = True
End If
End Sub
Thanks for your help!