Hi all,

I have a form called Invoice which has a subform (Continuous form) embedded in it.

e.g.
frmInvoice
txtInvoiceNumber
txtCompanyName

sfrmOrderDetails
txtItemID
txtPrice
ExtPrice

=Sum([ExtPrice])which calculate the sum


I want to print a report of this form

=[Forms]("frmInvoice")![txtInvoiceNumber]
=[Forms]("frmInvoice")![txtCompanyName]

for the data on frmInvoice work fine

but when I tried
=[Forms]![frmInvoice]![sfrmOrderDetails]![txtItemID]
=[Forms]![frmInvoice]![sfrmOrderDetails]![txtPrice]
=[Forms]![frmInvoice]![sfrmOrderDetails]![ExtPrice]

showed #Name?

How could I print these continuous subform data on the report?

Thanks for your hlep.

J.K.W.Y.

Create a report and print the report instead of the form.

HTH

mmcdonal

I tried to use the report wizard to create the report. But it shows all the invoices my database instead of the specific one that I want

You need to pass a parameter to the report. I am not sure what you PK field is on the form. DO something like this:

Dim stDocName As String
Dim iPKID AS Integer 'if it is an autonumber field, for example
Dim sLink As String

iPKID = Me.PKID
sLink = "[PKID] = " & iPKID
stDocName = 'rptYourReportName"

DoCmd.OpenReport stDocName, acPreview, , sLink


You will have to confirm the syntax for the DoCmd line, but you want the link in the WHERE section. Place a button on your form called "Preview Report" and put this code on the On Click event.

Alternatively, if your report is based on a query, in the query design view, in the PK field criteria section put this criteria:

[Forms]![frmYourForm].[YourPKIDControlName]

Then on the form, create a button to open the report and don't modify the code. When the query runs, it will pull the PK ID from your form and only open the report with the contents of the current form/subform data.

HTH


mmcdonal

Sorry, if you use this code, this line should be:

stDocName = "rptYourReportName"

not

stDocName = 'rptYourReportName"




mmcdonal