select multiple items in list to run query

[Rebecca]

I have several accounts (call them horse, dog, cat, fish). I have queries
that apply to any of these accounts (query1, query2, query3; or colors; food
brands; owners).

I am making a homepage where I want to be able to select mutliple accounts
(horse & dog) and run which every query/report they want (via a button). (So
for Colors, I'd get 5 rows for Horse-color1, horse-color2; and then 10 rows
for Dog-color1, dog-color2 -- 15 rows in all)

Using multi-select feature forlist boxes doesn't work--info doesn't go to
query's Criteria field (whereas if I have single-select, the query will
present just Horse data)

Any suggestions?
Thanks.

 

[Klatuu]

Multi Select List boxes are a bit different. The will not return a value.
The items that have been selected are held in a collection called
ItemsSelected. If you look in VBA Help under ItemsSelected, you will see an
example of how to interate throught the collection. Then, you will need to
build a criteria string using VBA to do your filtering.