Generating reports based on checkbox event

[pamireddy]

My problem goes like this.....
I have an access database file in which i have tables,forms,qu eries,reports and sub-reports...I have many forms in my database..The forms consists of many sub-forms in it...when i am executing a query on a form which has six sub-forms in it a report is generated with all the data of main form and data in six sub-form..This is working fine..But i wants the report to be generated only ifuser selects any particular sub-form..for example..there will be a check box on every subform..the data in that sub-form should be generated on report unless the user checks the chekbox..should i be writing some query for this action or should i be writing vb scripts for this event ..Am a beginner in vb script .please help me with code/query ..Any help from you would be appreciated..Ma ny thanks in advance

Regards

[Mihail]

For now I can see 2 approaches, depending how data from sub-forms are displayed in the report:
1) If you use sub-reports then you can show/hide the sub-reports based on the related checkbox value;
2) If the report is based on a query then design the query to select or none the records based on the check boxes values.

[maxamis4]

The other item to remember is that you will have pass through the filter into the report form. If you need examples with this please let me know.


Reference link
** SNIP **