[AccessD] Stop Code During Report

Rocky, 

I'm sending you a demo OL that shows you what I mean.

Charlotte Foust

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Tuesday, October 14, 2003 3:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Stop Code During Report


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
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com