Close a Report When Sub-Reports are Empty

Following on from my recent "RecordCount" thread ...

I have an unbound report which contains two subreports. I've used the method suggested by Al to count the records in the subs but I want the main report to close if both subs are empty. I've successfully trapped error 440 in various events but each time I use

DoCmd.Close acReport, Me.Name

I get an error saying that the action isn't possible whilst the report is formatting. Does anyone have a solution?

Many thanks.

Keith.

.

Relevant Pages

  • Re: Close a Report When Sub-Reports are Empty
    ... method suggested by Al to count the records in the subs but I want the main report to close if both subs are empty. ... I've successfully trapped error 440 in various events but each time I use ... I get an error saying that the action isn't possible whilst the report is formatting. ...
    (microsoft.public.access.reports)
  • Re: Limiting results per page
    ... the rotated lable control) is going to get pushed out at 29 rows. ... How can I either limit the report to 28 ... mind though that I need the subreport to not move to the 2nd page)? ... Static recordCount As Integer ...
    (microsoft.public.access.reports)
  • Re: Close a Report When Sub-Reports are Empty
    ... I have an unbound report which contains two subreports. ... report to close if both subs are empty. ... I've successfully trapped error 440 ... I believe you can use the ReportActivate event for this purpose: ...
    (microsoft.public.access.reports)
  • Re: Limiting results per page
    ... the rotated lable control) is going to get pushed out at 29 rows. ... How can I either limit the report to 28 ... mind though that I need the subreport to not move to the 2nd page)? ... Static recordCount As Integer ...
    (microsoft.public.access.reports)
  • Re: record count -1
    ... and a general lack of understanding of the different cursors types. ... was even a reported 'bug' in some ODBC driver that it returned an erronous ... Anyway a number of authors at this time and even MS tended to report that ... "RecordCount" may be unreliable, although has you pointed out such was never ...
    (microsoft.public.vb.database.ado)