Invalid reference for subreport in Parent OnFormat Event

[Jordan Fee]

I'd like to perform some conditional formatting in the OnFormat Event of my
Parent Report. This works fine, until my subreports are blank, then the
invalid references start happening. I understand why, but can't figure out
how to trap/prevent these. I tried using the hasdata property, but this also
gives me an invalid reference. Arrrrrgh.

[Elaine]

Jordan,

First, don't use OnFormat, use OnPrint. There are lots of sources
that will explain why.

Second, (maybe first in importance) check the order of events for
reports in the help file.

Also, I would investigate these:
* put each subreport in its own section
* set the section.visible = false if the subreport is blank
* check the section.visible property and don't fire the code for
that section if it is not visible
* make sure you are not referencing *anything* which could refer to
a subreport that isn't there outside the scope of the subreport

HTH,
Elaine
On Sun, 20 Mar 2005 22:38:22 -0500, "Jordan Fee" <W_*****@hotmail.com>
wrote:

I'd like to perform some conditional formatting in the OnFormat Event of my
Parent Report. This works fine, until my subreports are blank, then the
invalid references start happening. I understand why, but can't figure out
how to trap/prevent these. I tried using the hasdata property, but this also
gives me an invalid reference. Arrrrrgh.