Hold code execution

[AndreAraujo]

Hi,
I'm a having a problem with 2 reports, i have to print 2 reports , but the users need to preview the first report and print, and only then see the preview of the second report.
Is there a way to hold the program until the print of the first report????

Thanks in advance
André Araujo

 

[lupins46]

2 buttons?

 

[MakeItSo]

Put the "OpenReport" command in the "OnClose" event of the first report.
;-)


Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[AndreAraujo]

Hi, i get the solution from a thread by Trevor Best.

DoCmd OpenReport "rptWhatever", A_PREVIEW
Do While IsReportLoaded("rptReport")
DoEvents
Loop
DoSomeThingElse

Function IsReportLoaded(pstrReport As String)
IsReportLoaded = SysCmd(SYSCMD_GETOBJECTSTATE, A_REPORT, pstrReport)
End Function

Thanks everyone, Andreas Great tip.


André