[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