multiselect list box - Allen Brown code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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