query criteria - global variable

[leahf via AccessMonster.com]

For a parameter for a report, I have a multiselect listbox to choose
districts.

Using a global variable, I form a string with all the codes of the districts
that were chosen. I have checked the string and the lists of district codes
are correct.

In the district code field of the query for the report, I put in the criteria
" In (getstrDistricts())".

When I choose one district it works. When I choose more than one district,
the report is blank.

What am I doing wrong?

Leah

 

[Gary Walter]

For a parameter for a report, I have a multiselect listbox to choose
districts.

Using a global variable, I form a string with all the codes of the
districts
that were chosen. I have checked the string and the lists of district
codes
are correct.

In the district code field of the query for the report, I put in the
criteria
" In (getstrDistricts())".

When I choose one district it works. When I choose more than one
district,
the report is blank.

Hi Leah,

In(...) just will not work that way...sorry.

Typically, you have a form with a list box,
you click on command button to open report,
and in code for that event you save "list" in a
variable (say "strList").

Then, just before you open report, you merge list
with IN

strWhere = "[somefield] IN (" & strList & ")"

and use strWhere in the report open command...

DoCmd.OpenReport stDocName, acPreview, , strWhere

Will that work for your situation?

good luck,

gary

 

[leahf via AccessMonster.com]

Worked like a charm.

Thank you very, very much.

Leah

For a parameter for a report, I have a multiselect listbox to choose
districts.

[quoted text clipped - 12 lines]

district,
the report is blank.

Hi Leah,

In(...) just will not work that way...sorry.

Typically, you have a form with a list box,
you click on command button to open report,
and in code for that event you save "list" in a
variable (say "strList").

Then, just before you open report, you merge list
with IN

strWhere = "[somefield] IN (" & strList & ")"

and use strWhere in the report open command...

DoCmd.OpenReport stDocName, acPreview, , strWhere

Will that work for your situation?

good luck,

gary