Creating a Dynamic Report based on Form/Table Values

[thefirepig]

I'm sure there is a very simple answer to this Q....

I am attempting to create a report that's populated by checking boxes on a form. The form is used to specify conditions.

For example, on the form the user would check "Street Signs Required". Of course, when that happens I get a "true" in the table field that is the control source for the checkbox.

Now, when the report is run, I want text associated with all "true" fields to be placed in the report. For example, if the "Street Signs Required" box is checked, I want the text "Street signs must be installed at the intersection nearest your project" to be inserted into the report, and so on for each box that is checked.

For some reason, I cannot think of or remember how to do this...any help would be greatly appreciated.

 

[Crowley16]

I'm not sure if there's any easier way but what I would do is to create a dynamic sql statement, based on the check boxes, and then using that as the recordsource of the report...

--------------------
Procrastinate Now!

 

[thefirepig]

Or is this just a simple ad-hoc report that I am trying to overthink? - It would not be the first time

 

[dhookom]

I think the primary issue is your table structure. It is un-normalized. Each check box should be a record in a related table.

Consider what an Orders table would look like if you had a check box for each Product. How would you place the product names in a report? Luckily there is an OrderDetails table with one product per record with the OrderID to relate to the Orders table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]