Printing multiple records based on a field.

[Mik]

I have a database containing all students for our classes, and what class
they are taking. I need a way to print off each record, one per page, of all
students taking the same class. How would I go about this?

 

[DM]

do you have all your info in one table or multiple tables?

build a query based on the table(s). this will allow you to set parameter
(filters) for one page based on one course. this query can also be copied
and change the filter for other reports if you need them later.

generate the report to group by class and sort by student. once the report
is generated by the wizard, you can go in and the class group footer and
insert a page brake in that footer. this will allow the pages to start all
over with each class. granted you may have to play with the design of the
report to space the details in columns so you get all students on one page.

 

[Mik]

Sounds great, but I have 26 fields I need printed, and I need them only one
student per page. There are two tables in play, one listing all the classes,
and one holding all the students, with a drop-down box sourcing the classes.
I have a form that prints one student's info beautifully, but I'd have to
find each student in each class manually. Surely there is a macro or
something that will let me select the class I need, and it will automatically
print the records.

 

[DM]

Oh,

yes, create a form based on the class, drop an unbound combo box in to find
data by selection then create a subform to link to the parent form (linked
child and master fields). base the links on the class.

once everything is set, you open the form in view and use the dropdown box
to select a class to see what you want.

I do this for classes to see who is instructing on a certain day for a
certain class. I can also see what students are signed up for that class.