Form with subform to report (2 Viewers)

[Winterwolf73]

To say I am a newbie would be an understatement. I am still learning the ins and outs of access.

I have a DB that I am using to track some things for my fire department. I have a form that I can select the person which then shows their rank. There is a sub form in the form that lists all training that has been completed.

I need to be able to print training reports for each of my guys. I am able to pull the information by using the form that was built. But from everything I have read, forms do not like to be printed. Everyone says to use reports. Any advise on how I can pass the data from the form to a report?

 

[arnelgp]

there is a demo.
see the Code on the "Print" button (fitering the report before it is shown)

 

[arnelgp]

if you need to print all Firemen and their trainings, you remove the:

"FiremenID = " & Me.FiremenID

from the code of the Print button.