Sub Report Not Showing

[DS]

How do you get a Sub-Report to show on a Report even if the Sub-Report
has no records. I'd like to get it to show up with Zeros if they're
aren't any records.
Thanks
DS

[Trevor Best]

DS wrote:

How do you get a Sub-Report to show on a Report even if the Sub-Report
has no records. I'd like to get it to show up with Zeros if they're
aren't any records.
Thanks
DS

Hard with bound fields as with no records you generally get #Error or
something but you might be able to frig it, e.g.

Sub Report_NoData(whatever parameters)
txtSomething.ControlSource = "=0"
txtSomethingElse.ControlSource = "=0"
End Sub

Might work, I haven't tried it.

--
This sig left intentionally blank