form and subform data should be sent to a report

[Leaner79]

Hi,
I have a form with 3 subforms. All of the tables share the same primary key so they are linked..
I would like to have a report that prints the curent record displayed.
Hpw can i have the report have subreports?

 

[Pampers]

I would like to have a report that prints the curent record displayed.

Put something like this in the onclick() of the print button:

Private Sub cmdProforma_Click()
    Dim stDocName As String
    Dim stWhere As String
    stDocName = "rprtProforma"
    stWhere = "OperationsID=" & Me.operationsID
    DoCmd.OpenReport "rprtProforma", acPreview, , stWhere
End Sub

Don't understand the question:

Hpw can i have the report have subreports?

Pampers
You never too young to learn