open report if...

[Guest]

Win XP - Access 2003
I have a report that shows 4 yes/no checkbox fields.

The report is based on a query called boardsQry.

I only want the report to display records if any one of the 4 checkboxes are
checked true/yes (they don't all have to be checked - just one of the four).

What is the criteria in the query or in code on the open report event that
can make this happen?

Thanks in advance

 

[fredg]

Win XP - Access 2003
I have a report that shows 4 yes/no checkbox fields.

The report is based on a query called boardsQry.

I only want the report to display records if any one of the 4 checkboxes are
checked true/yes (they don't all have to be checked - just one of the four).

What is the criteria in the query or in code on the open report event that
can make this happen?

Thanks in advance

As criteria for each check field:
-1
Place the criteria one line below the preceding criteria so that you
get an OR orperator. The SQL view Where clause will look like this:
Where [Field1] = -1 OR [Field2] = -1 Or etc....

 

[Amy Blankenship]

On the on click event of each check box, check all check boxes. If any of
them are checked, enable the command button to open the form. If none is
checked, disable it.

HTH;

Amy