See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html
The article explains how to loop through the ItemsSelected collection of the
multi-select list box, to build up the Where clause.
You will need to apply that idea multiple times if you are using several
multi-select list boxes.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"syounger" <syounger@gmail.com> wrote in message
news:1120570775.681885.234750@g47g2000cwa.googlegr oups.com...[color=blue]
> Hi. I have a report in Access 2000 that is based on selection made
> from a series of interdependent list boxes. The boxes I have right now
> are Source, Table, Column, Date. The user chooses Source first, then
> the Table list box populates only tables from that source. Once a
> table is chosen, only the columns for that table appear in the Column
> list box. In the date box, the only dates that appear are those that
> are stored against the chosen column. I have a command button that
> then sends this information through a query to print a report based on
> the chosen criteria.
>
> Right now the query only accepts one value for each list box. I need
> to make the query recognize multiple selections, and I need the other
> list boxes to populate based on those multiple selections, then the
> report to print in this manner as well. So if my user chooses one
> source, they can choose two tables followed by multiple columns. This
> way they can print reports on notes on more than one column of more
> than one table at a time. Can someone please help me with this?
>
> Thanks in advance!
> Shannon[/color]
