[AccessD] Report's On Open

That's right Jim -- show me up! ;) Thanks!

Susan H.


> Hi Susan:
>
> Check out the coding examples at the DBA site... You remember the one I
> wrote and the one you reviewed. <a devilish grin>
>
http://www.databaseadvisors.com/newletters/newsletter112003/0311UnboundRepor
> ts.htm To summaries, the code sample makes good use of the Report's On
Open
> event by call a process that actually acquires the Report's data before
> displaying it. As you can see the process to filtering the data, or doing
> anything with the data you want is straight forward. Just about anything
can
> be added to the Report's On open event, even a form that would do the
> filtering.
>
> HTH
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
> 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
>