Print multiple reports choosen from a form.

[Wieli]

Hey,

First of all, I attached a sample base to more easy understand what i want.


I have a table ofcourse wiht all my data.

I then have a form with all the names that my tables includes. and after each name i have a checkbox.

I then have a report where in my sample it only includes Name,Age,Gender.

Now!



When i have selected the names i want to print reports for in my form, and then click "print checked" i want the VBA/macro to print 1 report page/person.


So first page would only include

Name: Mike Stevens
Age: 22
Gender: Male

Page 2 would look like this
Name: Anne johnsson
Age: 33
Gender: Female

I guess i would need to work with groups here so that i can have 1 persons information on each report page that i print.

What would be the best way to tackle this?

Any info and help would be appriciated.

[ssanfu]

Create your report. The recordsource should be a query based on the table. The criteria for the checkbox should be TRUE.
In the details section of the report, add the fields you want on the report.
Open the properties dialog for the detail section and click on the "Format" tab.
Set the "Force New Page" property to one of the selections.
Save report
Print report