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