More than 1 Report

[kbreiss]

I have a report that uses the following query to get it's info......

SELECT Inventory.*
FROM Inventory
WHERE [FORMS]![INVENTORY_FORM]![AUTO_NUMBER]=INVENTORY.AUTO_NUMBER;

On my form I have a "Print Report" button that runs this query.

My question is......
Is there anyway that I can get a button on a form that will print a report for each record that I have in my database? If so, please let me know. Thanks in advance.

Kacy
________
Kitchen Measures

 

[Newman]

You could put a SkipPage at the end of the details section. be sure that there is no spaces between the dots and the next section or else you'll get a blank page at the end. You might have to bring everything from the report header and report footer to the page header and page footer to get a nice report.
Hope that helps you!

 

[kbreiss]

Thanks,

I got something to work over the weekend. I created a report and then a macro that runs a query that gets ALL from my table. So my command button runs that macro. Works fine

Kacy
________
CoeD