Re: Multi Selection List Box

Thanks Klatuu,

I believe this is heading in the right direction but not quite. I tried
passing this but it didn't work.

I've been trying to pass this statement [FiscalPeriod] IN (2,3) for example
through the DoCmd and it runs the report but doesn't apply the filter. Any
ideas on this one?

--
Tony

"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E852611-C860-4315-B59E-3FD19D8BD98E@xxxxxxxxxxxxxxxx
As Duane points out, that syntax will not work. Change it to create a
string like this instead:

IN(1, 2, 3)
--
Dave Hargis, Microsoft Access MVP


"Tony" wrote:

I have a list box that I need to pick anywhere from one to twelve items
out
of at any given time (fical periods actually). With the data selected
from
this box I need to run a query that filters on the items chosen. I
already
have the code that populates a text field called "ListStorage," which
looks
something like this after a command button is pressed to run the script:
Like 1 Or Like 2 Or Like 3...

The query will not accept the data from my text box and no data is
displayed
when the query is ran.

I searched the Internet and found something that runs a script that
filters
the data one click at a time but I need to concatinate those clicks so I
can
print a report based on the items selected.

Thank you,
Tony





.