No data event

Im trying to set up a report that will print out another report only when the
first report is blank.

I place a open report macro into the on no data event of the first report
and get a runtime error of 2212 error when it trys to print the 2nd report
and cancel the first.

What is the best way to get this to work?

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Integrated user input to run 2 reports
    ... Private Sub Report_Close ... MonthParam when you close the first report so the second report can not get ... > Report2 is [Pet Partner Birthday Lables]> ...
    (microsoft.public.access.reports)
  • Re: Word Automation in Office 2000 and 2003
    ... to repeat the report, it bugs at the same place. ... Set oDoc = Nothing ... >> but bugs in the 2000 version after the first report has been produced. ... >> Dim oWord As Word.Application ...
    (microsoft.public.word.vba.general)
  • Re: Integrated user input to run 2 reports
    ... > So why is FindMonth selected in the "birthdays" report not ... > Private Sub FindMonth_AfterUpdate ... >>MonthParam when you close the first report so the second ... >>>>will close and your input form will close in the ...
    (microsoft.public.access.reports)
  • Re: Muti page report question
    ... You don't need code in the first report, ... only to code printing the first report and then the second report. ...
    (comp.databases.ms-access)
  • Re: Integrated user input to run 2 reports
    ... Private Sub FindMonth_AfterUpdate ... MsgStr = "Do you want to print labels for the birthday Pet ... report print everything. ... >Put the following in the Open event of the first report: ...
    (microsoft.public.access.reports)