multiselect list box - Allen Brown code

Based on other posting, i referenced the code from
http://allenbrowne.com/tips.html. I am having a problem getting it to work in
my query. I created the text box for Report.OpenArgs and i see the results of
the strWhere and i also see the results in the Report properties under
Filter. The problem is when the report opens there is no data. It acts like
the query isn't picking up the string. I know this is general info and i am
happy to provide more details but i didn't know if this sounded like a simple
fix. I'm sure i'm making a dumb error. Any help would be appreciated.

Thanks

The article at:
http://allenbrowne.com/ser-50.html
describes how to build two strings:
- strWhere is the WhereCondition that limits the report;
- strDescrip is a description of what the WhereCondition is aiming to
do.

You have succeeded in passing the description via OpenArgs, but the
WhereCondition is resulting in no matching records.

Add another text box to the report, and set its Control Source to:
=[Report].[Filter]
This should show you the WhereCondition.

Hopefully you can then determine why this condition returns no values.
For example, you could create a query into the same table(s) and paste this
WhereCondition into the WHERE clause in SQL View.

--
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.

"coachjeffery" wrote in message
...
Based on other posting, i referenced the code from
http://allenbrowne.com/tips.html. I am having a problem getting it to work
in
my query. I created the text box for Report.OpenArgs and i see the results
of
the strWhere and i also see the results in the Report properties under
Filter. The problem is when the report opens there is no data. It acts
like
the query isn't picking up the string. I know this is general info and i
am
happy to provide more details but i didn't know if this sounded like a
simple
fix. I'm sure i'm making a dumb error. Any help would be appreciated.

Thanks