Generate multiple reports from form looping though table fields

[TomYC]

Sorry for the long subject line--
I've not been able to locate a thread that addresses this, though it must exist!
I have a form that I use to define a query, from which reports are generated (date range, department, etc.). currently I am generating individual department reports by clicking on the dropdown cbDepartment on my frmReportGenerator form, and then Previewing each report, saving as Snapshot, emailing, etc.
Eventually I want to automate the entire process of generating and emailing, but for now I'd be satisfied with:
loop through each Department in tblDepartment as referenced by cbDepartment on the form, then output the snapshot file, capturing the Department name such that it can be part of the snapshot file name (e.g Engineering_042709.snp).
Perhaps this is a Reports issue rather than a Forms Issue?

 

[lameid]

Really, it is a VBA/Module issue.

Generically you would use a recordset and loop through all the records and programatically save or send the report to each department.

Do you have any experience with modules?

 

[TomYC]

Actually no, or rather fitfully, and without complete understanding.
I created a module I believe but failed in my effort to call it. Perhaps there is a thread on this?
I'm thinking I want, say, a recipient list generated by a query (q_Recipients), that I could display on a form as a list box (lst_Recipients). Is that how to approach this?