list box based on another text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have text boxes in my form.

listbox1 does a query to get a list
listbox2 does a query based on the value of listbox1

data

col 1 (listbox1) col 2 (listbox2)
a apple
a apricot
b boy
b bat

when I choose "a" in listbox1 the only values to show in listbox2 are apple
and apricot. The second text box has a query with a condition on listbox1.

everything works fine when I first open the form, but if I change the value
of listbox1 the second box will not refresh it valid list.

Thanks,
 
Back
Top