>Hello All,
>
>I have a form with 2 listboxes bound to 2 different tables (Rowsourcetype alias) which are related to each other.
>
>When I move in the first listbox I would like to see the filtered subset in the second listbox - but for some reason the second listbox ignores the set relation (it shows all the records all of the time).
>
>I could do it with a SQL where clause but that means i'm working with a cursor which makes table updates more hassle.
>
>Anyone have any suggestions?
I use set relation sometimes and have found that when I move the parent table I need to Select the child table just to wake it up to show what it is supposed to do. You might try that. When you move in the first list box then select the child table and refresh the second list box programmatically.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope