[AccessD]

I thought of that.  My biggest problems is that It may
need to be based on more than one of the filter
queries at a time.  Like I might want to filter out
extension to extension calls AND local calls so that
they're not displayed on the report.

--- "Marcus, Scott (GEAE, Contractor)"
<scott.marcus at ae.ge.com> wrote:
> In the Open event of the report, determine which
> query the report needs to
> be based on(the form check boxes) and change the
> recordsource via code.
> 
> Scott
> 
> -----Original Message-----
> From: Frank Tanner III
> [mailto:pctech at mybellybutton.com]
> Sent: Wednesday, July 30, 2003 10:57 AM
> To: Database Advisors
> Subject: [AccessD] 
> 
> 
> Ok.  Stupid question time....hehehe
> 
> I have a report that I want to run.  The report, of
> course, is based on a query (it calls the query as
> it's record source).  I have other queries that I am
> using as "filters".  I want to activate these
> filters
> based on check/uncheck boxes.
> 
> I have the check/uncheck boxes on a form.  The form
> calls the report.  How can I get the report to
> filter
> based on the "filter" queries I have written based
> on
> whether or not a checkbox is checked or unchecked in
> the main form?
> 
> Thank you for your assistance.
> _______________________________________________
> 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