Parameters based on Multi-Select List Box in Access 2000

syounger

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

Nov 13 '05 #1

Allen Browne

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" <sy******@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

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

Nov 13 '05 #2

syounger

okay so it makes sense, but i am still baffled... it's a bit complex a
maneuver for me, as i am sort of a beginner with this level of
manipulation in access and have next to zero VB skills... could you
maybe help me out with how you would apply it to multiple list boxes
that derive their data based on the box selected before? i can give
you examples of what the forms and queries look like right now when
they allow for single item selection...

thanks!
shannon

Nov 13 '05 #3

Allen Browne

I'm not able to complete your programming for you.

Take the example apart.
Understand what the ItemsSelected collection is.
Understand the target string using the IN operator.
Build up your string in the loop, and you're there.

--
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" <sy******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

okay so it makes sense, but i am still baffled... it's a bit complex a
maneuver for me, as i am sort of a beginner with this level of
manipulation in access and have next to zero VB skills... could you
maybe help me out with how you would apply it to multiple list boxes
that derive their data based on the box selected before? i can give
you examples of what the forms and queries look like right now when
they allow for single item selection...

thanks!
shannon

Nov 13 '05 #4