This should be a pretty simple answer to find but I haven't had any luck.
Here is what I have. I have 3 combo boxes. Each subsequent combo box is revealed when a selection is made in the previous combo box. All combo boxes have placeholder text.
Here is what the behavior should look like
Combo box 1(visible with no selection) > Combo box 2(hidden) > Combo box 3(hidden)
Combo box 1(visible with selection) > Combo box 2(visible with no selection) > Combo box 3(hidden)
Combo box 1(visible with selection) > Combo box 2(visible with selection) > Combo box 3(visible)
I'm pretty sure I need to use the Visible property and make it conditional on the value/status of the previous combo box but not completely sure how. What I have tried usually throws an error or does nothing.
@Future_Vision Assuming the first two are named Combo1 and Combo2, you would set the visibility of Combo2 to be
If(IsBlank(Combo1.Selected), false, true)
Then just duplicate this for the Combo3, but referencing Combo2.
Use this code in the Visible property of ComboBox2
!IsBlank(ComboBox1.Selected)
Then use this code in the Visible property of ComboBox3
!IsBlank(ComboBox1.Selected) And !IsBlank(ComboBox2.Selected)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Combo box 1 Visible property: true
Combo box 2 Visible property: CountRows(Combo Box 1.SelectedItems) > 0
Combo box 3 Visible property: CountRows(Combo Box 2.SelectedItems) > 0
Regards
Krishna Rachakonda
If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone. |
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional