populate combo-boxs and listbox
I'm new in vba. I'll appreciate for any help.
I have database and need to create form with 2 combo-boxes and listbox. It should be work by select value in first combo-box I need get depedens values in second combo-box and from second combo-box get dependens values in listbox. Populate listbox from second combo-box I done. It look like:
Private Sub Combo2_Change()
Me.List4.RowSource = "Select Result from v_Result where Proc_Id = " _
+ Me.Combo2.Value
Me.List4.Requery
Me.Combo2.Requery
End Sub
and now my problem include to process first combo-box.
Thanks for any help.
|