[AccessD] Report's On Open

...take a look at KB208529 :)

William Hindman
There are no easy answers, but there are simple answers. We must have
 the courage to do what we know is morally right." --Ronald Reagan


----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, December 22, 2003 11:07 AM
Subject: RE: [AccessD] Report's On Open


> Susan,
>
> I use it but I haven't done that.  What you could do is to pop up a
> dialog (i.e., inputbox or modal popup form) to grab info and generate a
> filter string in the report's Open event.  It wouldn't be too difficult,
> but the interaction would stop there.  Once you had grabbed the
> information, you would want to close the form/dialog.  I doubt that the
> author is talking about some kind of interaction with a persistent form
> opened by the report.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Susan Harkins [mailto:ssharkins at bellsouth.net]
> Sent: Saturday, December 20, 2003 2:32 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Report's On Open
>
>
> I read about a technique in a fairly new Access 2002 book that you could
> use a report's On Open event to filter the data. The section didn't give
> details, it just referred to displaying a "dialog" in the On Open event.
> Now, I know you can pass criteria via the OpenArgs property, but the
> author doesn't seem to be talking about this. In fact, the process seems
> turned around -- the report displaysing the filtering form, not the
> other way around.
>
> Does anyone actually use the report's On Open event to somehow grab
> filtering data? I'd like to hear about it if you do. Keep in mind, I'm
> not talking about displaying a filtering form and then passing the
> criteria via an OpenReport -- I'm talking about opening a report from
> the Database window and letting the report's On Open event display a
> filtering form. I don't see how this would be possible -- how would you
> stop the report from populating while the Open event displayed a form
> and the user selected options?
>
> Susan H.
>
> _______________________________________________
> 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
>