I am trying to create a form that has over 25 check-boxes that a user can select (i.e. 1, 2, 3, ..... or all 25). I know that there is some type of nested loops or IF-Then statements that need to be created for them. I am tying the selections to 5 tables because there is a large amount of data that is being compiled. I am just baffled on how to get them to work. Any help would be greatly appreciated. Thanks!!

Welcome to Wrox.

When you say, "I know that there is some type of nested loops or IF-Then statements that need to be created for them."

That is only true if you have some conditional event that happens when some of them are checked or some combination of them are checked. Before we can help you answer your question, you need to tell us your requirements. For example,

"I need this report to open if the first five checkboxes are checked."

"I need this form to open if the checkboxes having to do with inventory are checked."


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

25 check boxes is not a large amount of data. That can all be stored in one table. What other data is being gathered? Is this just a data entry form, or is it calling reports or another form, etc.?



mmcdonal

After the check boxes are selected, the user clicks on "Preview Report" and a report is generated. I have 200 systems that can have many capabilities. I have 5 tables, 2 are system users and enclave (security requirement) and the other 3 are groups of capabilities. All of the tables are tied into the systems table. What we are wanting is for the user to select the capabilities, system users, and enclave; then a report is generated to show what systems meet that criteria. The same report will appear just with different systems. Thanks again for your help!!

tina

Wow, you can have lots of different ways to open these reports.

You can issue a DoCmd.OpenReport with a very long criteria argument.

You can have the report open and then check the values of all the checkboxes on the calling form and then hide/show subreports based on those checkboxes.

You can have one report open but its record source could change based on the selection of checkboxes.

You can set up multiple reports and which one opens depends on which checkboxes are true.

Etc.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division