Hello!!
This is my first thread for any Access forum, and I'm not much of a database guy, sooo.....
Initial Conditions:
Query that pulls data - including a field called [Facility] - from several tables.
A report that is generated using "Click()" in my main menu. The code passes the [Facility] by way of an "i" value in an array of facilities. The report opens, does its thing, saves a PDF, closes the report, then goes to the next "i".
Desired Result:
Without limiting the query to only 10 results, I would like to stop the report at 10 results, using the "=1" text box value when it hits 10.
I've tried a lot of different paths, but the report still runs all results for each report, which can be 100+.
Thanks in advance!