list box based on another text box

[stickandrock]

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,

 

[Brian Bastl]

in the afterupdate event of listbox1

me.listbox2.requery

Brian

 

[stickandrock]

who would have thought... requery

Thank you for the help