[AccessD]

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