Print Collate Multiple Reports by Individual

[Mikki]

Good Day~
I have a class roster and need vba code to print a first day package of forms. I want them to print each person's package then move on to the next person until the roster has printed each person's package.
Any help would be appreciated~mjc

 

[llkhoutx]

Use a form filter to modify the report record source (query) each time the form filter changes. You can also modify the filter via VBA and generate all the report by one click.

 

[Mikki]

Thank you for your reply.
Will the filter make it print by the individual?
I want it to print all forms for Joe Doe then move to Jane Doe print all, then move to Sam Doe, etc.
Thanks again~mjc

 

[llkhoutx]

I presume that you have a list of class members and the "forms" applicable to that member. Maybe all members have to same "forms" with pedestrian information changed.

If all the "forms" are not in one report, generate multiple reports, with each report, have it's record source filtered by the class member, either picked up from a table or query, or a combo box on a form which you change and then click a button for the report generator.

With the requisite knowledge, it is very simple. The pororts may or may not be tedius to physically specify.

 

[Uncle Gizmo]

I recently answered a similar question which you can find in this thread here:-

Form saving several reports in one go

I also did some YouTube videos explaining what is required HERE:-

There is a Google presentation which I have gone through in one of the videos and the Google presentation "Generate Multiple Reports" is here:-

 

[Uncle Gizmo]

Useful if you watch a lot of YouTube videos to learn Stuff:-

YouTube Time Saving Tip!