How to print form and sub-form together

[Hairy64]

We have developed a form (not a report) which has personal information on it and a sub-form which then shows all the training this person has had.

When we put a print button on the form with code to print the form, the sub-form is dropped off. The VBA coding is simple:

Private Sub Print_Click()
     DoCmd.PrintOut
End Sub

How do we correct this?

Thanks in advance.

 

[dhookom]

You correct this by creating a report with a subreport for printing.

Duane
Hook'D on Access
MS Access MVP

 

[Hairy64]

Thanks Duane,

But if you can print a form, why not the sub-form with it?

Michael1947
"There are 10 kind of people in the world. Those who understand binary, and those who don't

 

[dhookom]

Your subform should appear on the printout. I just opened the sample Northwinds mdb and did a print preview of the Orders form. I am seeing all of the order details records in the subform.

I would check various properties of the subform control to see why your experience is different.

Create reports with subreports ;-)

Duane
Hook'D on Access
MS Access MVP