Multi-MultiSelect With 'All'

[skea]

Now i need some help here.
I adapted this code from somewhere on this forum. But iam having a problem with using the 'ALL' criteria.
It Opens a Report Dynamically from multiple selections in the two multiselect ListBoxes, but when i select 'All' and select any other item in another listbox
For Example(All in Names and Home1 in Homes) it gives me all the Results.
I have tried several criterias to solve it out but iam still failing.
Hope there will be help. Attached is a sample db in A2K and A97.
Thanks in Advance.

 

[WayneRyan]

skea,

Your variable flgSelectAll is trying to work for both ListBoxes. It
should be an array.

Your code also falls into the Error Trapping routine which might lead
to a hard-to-find error.

I generally use the "Where Home In ('Home1', 'Home2')

There are examples in the Sample Database Forum.

Wayne

 

[skea]

Thanks Wayne,
i will give it a go.

 

[skea]

For Any Beneficiaries, here is how i made it up.