Subreport empty

  • Thread starter Thread starter antgel
  • Start date Start date
A

antgel

Hi all,

Sorry for the cross-post, but I think there are issues pertaining to all
groups.

I have a report rptInvoice (bound to qryInvoiceDetail), with subreport
rptInvoiceLineDetail (bound to qryInvoiceLineDetail).

The reports are linked by qryInvoiceDetail.id and
qryInvoiceLineDetail.invoiceid.

When I open the report from a form (also bound to qryInvoiceDetail), the
subform is coming up blank. However, if I open the report from the Reports
section of the Database window (with nothing else open), it's ok. I can
also do an inner join between the two queries in question, and display all
fields.

Any ideas anyone?

Antony
 
antgel said:
I have a report rptInvoice (bound to qryInvoiceDetail), with subreport
rptInvoiceLineDetail (bound to qryInvoiceLineDetail).

The reports are linked by qryInvoiceDetail.id and
qryInvoiceLineDetail.invoiceid.

When I open the report from a form (also bound to qryInvoiceDetail), the
subform is coming up blank. However, if I open the report from the Reports
section of the Database window (with nothing else open), it's ok. I can
also do an inner join between the two queries in question, and display all
fields.
Click to expand...

Hi Anthony,

I am a bit confused.

Opening a "report from a form" suggests to me
a command button on your form whose click event
code looks similar to:

Dim strDocName As String

strDocName = "rptInvoice"
DoCmd.OpenReport strDocName, acPreview

But then you say the "subform" is blank.

Did you mean the "subreport" is blank?

Or are you trying to create a form/subform
that is like your report and the *subform* is
coming up blank?

Please respond back and I will try to help.

Good luck,

Gary Walter
 
Back
Top