multiselect problem

[tod4]

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]

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

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

-Tom.

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