Report with partial open records (1 Viewer)

[dab1477]

I have a database as follows:
Date1 Name Issue Action_Item1 Status1 Action_Item2 Status2 .....

with up to 5 max action items/status; where Status is a checkbox

I ONLY want the report to return records where there is text in an action_Item input AND the corresponding status is FALSE.

The issue I'm having is that there may be ACtion_Item inputs withOUT text; so I can't simply query the Status checkbox for false.

How do I code this? Don't know how to get started.

Thanks in advance from an intermediate newbie in VBA

 

[TJPoorman]

In your WHERE clause do something like:

(Action_Item1 Is Not Null AND Status1=False) OR (Action_Item2 Is Not Null AND Status2=False)...

 

[dab1477]

Still need help. I have the following code:

Private Sub Report_Open(Cancel As Integer)
Dim Action_Item_1 As String
Dim Action_Item_2 As String
Dim Action_Item_3 As String
Dim Action_Item_4 As String
Dim Action_Item_5 As String
Where (Action_Item_1 Is Not Null And Action_item_1_Status = False) Or (Action_Item_2 Is Not Null And Action_Item_2_status = False) Or (Action_Item_3 Is Not Null And Action_Item_3_status = False) Or (Action_Item_4 Is Not Null And Action_item_4_status = False) Or (Action_Item_5 Is Not Null And Action_item_5_status = False)
End Sub

I am getting a compile error: Type Mismatch.

Any ideas?

Thanks,