By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Generating reports based on checkbox event

P: 1
My problem goes like this.....
I have an access database file in which i have tables,forms,queries,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..Many thanks in advance

May 3 '12 #1
Share this Question
Share on Google+
2 Replies

P: 759
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.
May 4 '12 #2

Expert 100+
P: 295
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 **
May 7 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.