Auto Print Report for each record in table...

[access32]

I have a query that pulls information from three different tables. I have setup the query to prompt for username. When I open the report based on this query, I am prompted for a username. I enter the username and the report opens the report for that user.

What I would like to be able to do is have access automatically print this report for each user in my table. I need a seperate report for each user and it takes time opening the report and enter each username
separately. Thanks in advance for your help!

[ajetrumpet]

I don't know much about printing in access, but the ribbon might give some options for printing each records. and alternatively, you could export each record out to separate sheets in one workbook to excel and print the entire workbook.