newb. need to have two list boxes on a form and controls 4

[yehong]

I am using Access 2002. I am desidning a form where I have two list boxes next to each other like following:

------------ -----------
| | > | |
| | >> | |
| | < | |
| | << | |
------------- -----------

I need to select either one value or multiple values from left list and move to right list and vice versa. Then I need to select * values from the list on the right and select data from tables by passing those values as a WHERE clause. Is there any tutorial or easy way to do this? Thanks in advance.

 

[PHV]

Have a look at ItemsSelected

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yehong]

Hi PH, You happen to have a sample code or link where I can find some samples for moving items from one list box to another? thanks.

 

[Eupher]

Hi, yehong,

Take a look at faq702-4246 for one technique. As an alternative, I have a sample DB here that demonstrates a variation (I really should post an FAQ on this!). Both techniques work, have a look and see what fits for you...

Ken S.

 

[obli]

I found this in a search and didn't have time to read it thoroughly and I have to leave work in just a minute but this might be what you're looking for. thread702-946254

 

[yehong]

Thanks guys for your help. I have successfully created the pair of list boxes and everything is working now.