You can set the properties of the 2nd listbox in its INIT method. The RowSource should be something like "select descript, keyid from choices_table where ParentID = ?nParentID order by ..."
When the user chooses something from the first list, set the value of the nParentID variable and call REQUERY method of the 2nd listbox.
>Hello, i need to use two list boxes both are chained, like this:
>
>list box1:
>fruit
>animals
>colors
>and if the user choose any of the list above in the second list box should appear:
>
>listbox2:(Choose animmals)
>dog
>cow
>bird
>how can i do this if i have to use queries on both?
>Do you have a better idea?
Mark McCasland
Midlothian, TX USA