Prev: append crosstabs
Next: M
From: turks67 via AccessMonster.com on 22 May 2010 11:32
I'm trying to open Two reports with one command button. But everytime I click
the command button it
goes to the report2. How can I open report1 click until I get to the last
page on report1 then open report2. Is this possible.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1

From: vanderghast on 25 May 2010 08:14
Maybe the easiest solution would be to open Report3 having Report1 and
Report2 as sub-report, if it is applicable in your scenario.

In the button click procedure, you can check to see if there is actually a
given report open, or not, using, among other possibilities:

if Application.SysCmd(acSysCmdGetObjectState, acReport, "myReportName") <> 0
then
DoCmd.OpenReport "myReportname", acViewPreview
else
DoCmd.OpenReport "otherReportName", acViewPreview
end if


(note that technically, you could also check to see if the second report is
already open).



Vanderghast, Access MVP


"turks67 via AccessMonster.com" <u48755(a)uwe> wrote in message
news:a863e41a87def(a)uwe...
> I'm trying to open Two reports with one command button. But everytime I
> click
> the command button it
> goes to the report2. How can I open report1 click until I get to the last
> page on report1 then open report2. Is this possible.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1
>

 | 
Pages: 1
Prev: append crosstabs
Next: M