List box and multiple queries

[Guest]

Hello everybody.
I have a form with 2 listbox and a button where the first listbox has three
values (S;N;T), the second list box is a filtered record list and button
execute reading data for populate the second list box.
This is the problem: after user had selected the code from first listbox and
pushed the button, I want use different query (dependind of user choice) for
populate the second listbox.
I have tried some ways, without results.
How I can different query for the same listbox?
Many thanks in advance for help.

 

[Ron2006]

In the afterupdate event of the first list change the recordsource of
the second list dependent on the value in the first box AND then
requery the second list

Ron

 

[Guest]

Thanks,Ron.
I ask myself how I don't arrived alone...probably too job.
Bye