Populating second combo based on first combo selection

[pinky]

I have (yes, no, other ) in one combo box and (open, no, other) in another combo box. When Yes is selected in first combo box, open should be automatically be selected in second one. How can I do that?

Thanks
Pinky

 

[SOS]

Just set the value of the second combo in the After Update event of the first combo:

If Me.ComboName = "Yes" then
   Me.YourSecondCombo = "Open"
End If

and you can also add any others there as well (what happens if NO is selected?).

 

[pinky]

Thank you. I tried this earlier exactly same but it did not work. But now it worked .


Thanks,
Pinky

 

[SOS]

Happy to help