List box and multiple queries

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

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.
 
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
 
Back
Top