getting a query to ask until seeing a null

  • Thread starter Thread starter Guy Story
  • Start date Start date
G

Guy Story

I am working on a form that needs to be able to be given a list of names
and then give me a list of specific criteria. I want to give it the
names of people and then get back what they owe or have paid. The list
of names will vary on a day to day basis. How can I get the query to
keep asking until I give it either no more names or a a prompt to finish
and generate a report? The form is where I put in my search criteria
for the query or is there a better method?

Thanks in advance,

Guy
 
The Parameter box popped up by a query is not powerful enough to do this.

One approach would be to put an unbound multi-select list box on a form.
Click on the people whose records you want to see, and then click a button
to filter your form to these people or open a report showing the results for
these people.

There's an example of how to do that in this article:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html
 
Allen, I toyed with the example and that is in the neighborhood of what
I need. Thanks. I did find a possible typo on number 9. It shows two
[[ at the start of Report. I had to remove one to stop and error when I
hit the command button.

Thanks again for the help.

Guy
 
Back
Top