I have a report that is queried by the ID # of a student - I have the following in the criteria of the query -

[Record ID 1] Or [Record ID 2] Or [Record ID 3] Or [Record ID 4] Or [Record ID 5] Or [Record ID 6] Or [Record ID 7] Or [Record ID 8] Or [Record ID 9] Or [Record ID 10]

This naturally prompts me to input 10 individual ID #'s. This works well; however, there are some instances where I only need 2 records as opposed to 10 whereas I input the first, then the second and then continue hitting the enter key until i have reached 10- then the report runs. There are also occassions when I need to pull more than 10 records whereas - I run the first query, print my reports and then run it again to get the additional records

Is there another way to write the criteria or to stop the query after the records needed rather than continuing to hit the enter key or to continue past the 10th record without adding [Record ID 11] and so forth?

As, I mentioned - this format is working well - I was just curious if it could prompt me to enter as many as I need and end when I've entered as many as I need.

Thanks.

Hi,
you could instead create a form and then reference form controls in the criteria in similar matter. This way you can control what to show up and fill out and what not.
HTH
Good luck

A better way to do this is with a multi-select list box. I have attached a database showing how I do it. See frmListCriteria.



Edited by: fkegley on Tue Jan 3 14:47:19 EST 2006.