How can I run multiple reports from a list from a form/table field

[Mike Ayres]

I have a report that runs from a query to select/collect data for filling out fields on the report. Lets call it an item number report.
Every day I want to print from 25-60 of these reports and each of them is based upon a list of item numbers that change from day to day.
So, I want to list the items to print for each day, have Access grab the data for each item, and print the list of reports.
I have built a table/form to list the items to print for each day, but don't know how to cycle down the list and print my reports that run for each item.


Presently I have to print each report one by one by requesting the item number in my query. I run the report, which runs the query (which requests the item number and associated data) and the report prints out. Then I repeat the process 25-60 times. If I could just run the whole batch of reports from a list each day it would be much simpler/quicker.
I am not a programmer per se, so would like to accomplish this process with ready to use Access tools if possible....
I have put together LOTS of reports, queries, and some macros over the past dozen years.
Hope some one can lend me some assistance -
THANKS!
mike

[June7]

Sounds like will need VBA code to open a recordset of the desired item numbers, loop through the recordset to reference each item number as criteria for the report.

What is the form structure - is it bound to a table? Can try the form RecordsetClone method, something like:

With Me.RecordsetClone
While Not .EOF
DoCmd.OpenReport "reportname", , , "ItemNumber=" & .ItemNumber
.MoveNext
Wend
End With

[Mike Ayres]

Forgive me for not being able to relate to all your comments - as noted previously - I am NOT a programmer and have taught myself to use Access simply by taking a few basic one day courses from a local community college about 12 years ago and then working my way through Microsoft Access tutorial book at the 2000 year level. I do understand the basics and have used and put together many databases for company use over the years - but they are generally simplistic. The data I need to print is all contained in a couple of linked tables. I only wanted to use a form (rather than a table) as a mechanism to list the items I wanted to print and then to place a button there for a user to press that was attached to a macro to run the list of item reports after they had them all input. So the form is only a different visualization of a column from a simple table. Unfortunately I'm not familiar with the form RecordsetClone method - if this is not too difficult and is the easiest way to get to where I need to go - I'm willing to learn if you can direct me somewhere? Thank you.

[June7]

I don't know any specific reference sources for the RecordetClone method - will have to just google it.

Build report that has ItemNumber as a field in its RecordSource. Then the WHERE CONDITION argument of OpenReport will filter report to the specific item.

If the form has the desired item numbers listed then the basic code I show is relevant.

How you filter the item numbers on the form to show only desired items is another issue.