Macro to run the same report for muliple users

[data123]

I have an access database were I have set up several reports that
need to run for 40 users. How can I set up a macro that will allow m
to run and export all 40 reports for each individual user by userid
For instance I need to run a usage report for each of the 40 user
individually, they all need to be exported to an excel spreadsheet.
familiar with how to set up the exporting, but not for sure on how t
get the report to generated based on userid all 40 times. :?

 

[Guest]

Create a form named TempForm with an unbound textbox with Visible property
set No.
Use the TempForm textbox as criteria for the query used as record source for
the report.
Macro -
Open form - TempForm
SetValue - [TempForm]![textbox] - UserID (1st ID)
Open Report
SetValue - [TempForm]![textbox] - UserID (2nd ID)
Open Report
SetValue - [TempForm]![textbox] - UserID (3rd ID)
Open Report
etc ...
Close form - [TempForm]![textbox]