By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,358 Members | 2,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,358 IT Pros & Developers. It's quick & easy.

multiselect problem

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.