Hi all, I was wondering if anyone could help me with something, I couldn't find my specific problem using the search. I'm not a newbie at VB but I'm not an expert either, so . . .
I have a form with 2 combo boxes on it. The user will select 1 of 2 selections in the first combo box. If they select the first item in the first combo box, I want a certain list of items to show up in the second combo box. If the user selects the second item in the first combo box, then I want an entirely different list of things to appear in the second combo box.
Problem: I can seem to get *anything* to appear in the 2nd combo box! I am trying to control what happens in the 2nd combo box in the code for the 1st combo box - after all, that's where the list for the 2nd combo box will be determined.
Here is my code:
First combo box:
Private Sub Combo1_Change()
If ListIndex = 0 Then
Combo2.ListIndex = 0 ' the VB documentation said to add this
Combo2.ListIndex = 0 ' ditto
At this point I'm not worried about code for my 2nd combo box, I just want the right selections to show up in the list!
Any help is appreciated.