If i have a table like this:
U I AbsTime TypeOfFile
2 0.01 0000001 000001-D00
3 0.01 0000002 000001-D00
4 0.01 0000003 000002-D00
7 0.02 0000004 000003-D00
5 0.03 0000005 000001-D04
6 0.01 0000006 000002-D04
And i have made two combo boxes (on a form) where you can select one of the fields; either U,I,AbsTIme or TypeOfFile. And the other combo box where i have added the parameters D00,D01,D02,D03,D04.
How do i populate a listbox based on the selections from the two combo boxes?
i.e if i choose combo1 = U and combo2 = D00 i want the textbox to be populated with:
000001-D00
000002-D00
000003-D00
Where 000001-D00 corresponds to U = 2 and 3; and 000002-D00 corresponds to U = 4; and 000003-D00 corresponds to U=7.
Thanks a lot
----==== Edit =====----
i have tried something like:
Expand|Select|Wrap|Line Numbers
- Private Sub Combo2_AfterUpdate()
- Me!List12 = Me!Combo2.Column(0)
- End Sub
Cheers