Subform per page

[EivisN]

May you know whit might i have done wrong. I did everything as it shown, but as I open Invoice form (also I converted Invoice form into report but same problem) on Print preview it shows every Invoices subform in one page while I need to print only one Invoice with his own subform. Any ideas ?


Made by this video https://www.youtube.com/watch?v=E8cP4dHZtVg

[ranman256]

Open the report or form using the ID of the cclient?
ina subForm design, set the property
LINK PARENT FIELD
and
LINK CHILD FIELD
to the ID.

The query do the report can look at the ID,
select * from table where [id]=forms!myForm!ID

or open a report with a filter,
docmd.openReport "myReport", acViewPreview,,"[id]=" & me.ID