[AccessD] Stop Code During Report

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Oct 14 18:02:22 CDT 2003


Charlotte:

Not completely confused.  Partially. :)

So what I have now is:

Some Code 1

DoCmd.OpenReport "rptX", acVeiwPreview

Some More Code 2

So I would put Some More Code 2 into another module and run it from the
OnClose event of the report?

How do I run that code from the OnClose event of the report?

Thanks and regards,

Rocky


----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, October 14, 2003 12:50 PM
Subject: RE: [AccessD] Stop Code During Report


> You could use WithEvents from the calling form to open the report and
> trap the Report_OnClose event.  The code in the routine that opens the
> report would end after opening the report, but the local OnClose event
> for the report would trigger whatever code you put into that custom
> routine.  That's the way I normally do it.  Does it sound completely
> confused?
>
> Charlotte Foust
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Tuesday, October 14, 2003 11:25 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Stop Code During Report
>
>
> Dear List:
>
> Is there an easy way to suspend execution of code while a report is
> open?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list