multiselect problem

[tod4@wp.pl]

Hi,
My problem:
I have query with value klient and product. On my form Im using
multiselect box as filter of klient value. Now I would like to use
second multiselect on this form for product value selection but only
for those value that are filtered by first multiselect. I dont know how
to connect selected value klient from first multiselect and value
product from query and make it source of multiselect 2.
Maybe someone did it before or have some idea.
Thanks very much for your sugestion.
Piter

[Tom van Stiphout]

Re: multiselect problem

On 25 Jul 2005 06:46:04 -0700, tod4@wp.pl wrote:

This code could be in the Listbox1.AfterU pdate event.
Iterate over the SelectedItems collection of listbox1, concatenating a
comma-separated list of ID values. Let's call it strSelectedItem s.
Then change the RowSource property of Listbox2 to:
"select * from SomeQuery where SomeID in (" & strSelectedItem s & ")"

-Tom.

[color=blue]
>Hi,
>My problem:
>I have query with value klient and product. On my form Im using
>multiselect box as filter of klient value. Now I would like to use
>second multiselect on this form for product value selection but only
>for those value that are filtered by first multiselect. I dont know how
>to connect selected value klient from first multiselect and value
>product from query and make it source of multiselect 2.
>Maybe someone did it before or have some idea.
>Thanks very much for your sugestion.
>Piter[/color]