Hide ComboBox until other ComboBox is populated

[jeepxj3]

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!

[orange]

Is Treatment2 dependent on the Value selected in treatment1?

[jeepxj3]

Is Treatment2 dependent on the Value selected in treatment1?

Yes, you must fill in "Treatment1" before "Treatment2" is available. (hope this helps)

[orange]

What part of cascading combo doesn't apply? I'm quite sure you could make treatment2 visible once treatment1 is selected..

[jeepxj3]

What part of cascading combo doesn't apply? I'm quite sure you could make treatment2 visible once treatment1 is selected..

I dont want the combobox2 to display at all until combobox1 or "Treatment1" is chosen.

[orange]

So on your form Load event set treatment2 visible = False
and when treatment1 is selected, make treatment2 visbile = true, and adjust the
record source to use the value selected in treatment1.