Thread: Report
View Single Post
  #2  
Old May 25th, 2010, 01:14 PM posted to microsoft.public.access.queries
vanderghast
external usenet poster
 
Posts: 593
Default Report

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@uwe wrote in message
news:a863e41a87def@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/For...eries/201005/1