Re: Trying to get fancy

I have always added a Boolean field to such tables and used a fake listbox
in the form of a continuos form
I maintain the "state" between reports and have a "Select All" and "Clear
All" button under the box.
One nice thing is that they can come back and run it again without having to
go through the selection process again.

They check what they want to see and run the report from the form.
It can work well for two or more choices as in "I want to see tests A,B,C
done by doctors Smith, Jones and Death between this date and that date."

No code to write and you just add a Field = True to teh query.

JimS wrote:
So, my users are asking to run their reports, integrity check query
displays, etc. by selection criteria. Say, for example, they want to
run an integrity check query that selects 1 or more "ProjectStatus"
values. I've been interposing a form that presents the project status
choices in a list box and lets them choose. Then I execute the form
or report out of that form.

But query displays are different. And I'm tired of reinventing the
wheel. I want to have a generic "choose Project Status" routine that
returns a string -- "(3,5,7,8)" for project statuses 3, 5, 7 and 8. I
can then use the "IN" operator to code the where clause in my SQL
statement or domain aggregate call.

I can't get by the notion that a function isn't a form, so can't
present a list box control and return the selections. I could have
the function "call" the form, but how to return the results to the
function? What's your solution?


.