Jim Lawrence (AccessD)
accessd at shaw.ca
Sat Dec 20 16:58:35 CST 2003
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