[AccessD] Report's On Open

Your Open event procedure assumes the filtering form is already opened and
criteria options selected. If it isn't, you make a default selection. I'm
talking about an Open event procedure that actually opens the form so the
user can make choices. I'm questioning whether you could (or even should)
make choices after the report is opened.

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
>