I'm using 4 list boxes whose data all depend on the previous ones selection by using queries and when each one is updated the rest of them all refresh to show the available selections.
For eg Listbox 1 contains values "Horse Racing", "Football" & "Other Sports".
If you select "Football" the 2nd listbox displays "Football" & "Live Football".
If you select "Live Football" the 3rd listbox displays all the Live Football matches for the week with associated figures.
What I need to be able to do is that when I select say "Live Football" out of list box 2 how do I write code to make access auto select the 1st record in list box 3 just so the boxes are never left in limbo waiting for a particular selection.
I'm sure this is simple........if you know how.
Thanks.
Jamie. Thanks
Jamie
For eg Listbox 1 contains values "Horse Racing", "Football" & "Other Sports".
If you select "Football" the 2nd listbox displays "Football" & "Live Football".
If you select "Live Football" the 3rd listbox displays all the Live Football matches for the week with associated figures.
What I need to be able to do is that when I select say "Live Football" out of list box 2 how do I write code to make access auto select the 1st record in list box 3 just so the boxes are never left in limbo waiting for a particular selection.
I'm sure this is simple........if you know how.
Thanks.
Jamie. Thanks
Jamie