Print a Report for each item in a query

[hext2003]

I have a form. There is a check box on the form. If we want a one page report printed for this item we click on the check box.

We go thru all of the current items and check this if we want to print this one page report (always the same report but different items). I now want to create a button that says print reports. When I click this button I want to print all of the reports that I checked the box for.

Any ideas of how I can do this. I was going to print each time a box was checked but then I am printing thru out the day. I want to be able to print them all at one time.

I have a query called need to print. This has the item numbers in it that need a data sheet printed. How can I write some vb code to get the first item number from this query?

Here is the Pseudo code

While (Query number of records is not zero)
Get first row item number
Print this Report
put date in printed field
Refresh query
loop

I know how to print the report for an item, and fill in the date field. I just don't know how to get the item number in row one of the query or how to check if the query is empty.

any advice would be greatly appreciated. If there is a better way please please share!

TIA

 

[hext2003]

Sorry, I was just being stupid....

I thought I would have to walk thru the query printing each one separately. duuuuuhhhhhh

I just linked the report right to the query and it printed all of the items.