curious80237
Last Activity: Sep 3 '09, 02:30 PM
Joined: Aug 31 '09
Location:
-
Unfortunately, I can't, because of the confidentiality of the data.... -
tried again
Delerna, thank you for your response. I tried both your suggestions for if ALL of the checkboxes are false then hide subreport (which is what I'm looking for). Both resulted in the subreport being hidden in every instance.
Any further suggestions are absolutely welcome.Leave a comment:
-
Here's the code as entered:
Private Sub Report_Open(Can cel As Integer)
If COA_Required = True Or Officer_Require d = True Or Designated_Eng_ in_Resp_Charge_ Required = True Or Local_Office_De signated_Engine er_Required = True Then
[Qualifiers].Visible = True
Else
[Qualifiers].Visible = False
End If
End Sub
The subreport is not visible. If I flip the [Qualifiers].Visible...Leave a comment:
-
If..then statement involving checkboxes
In Access 2003: A table with four yes/no fields is part of a query used as data source for a report. The yes/no fields show in the datasheet and the report as checkboxes; the default value of the field is "no". The report pulls in a subreport. I want the subreport to be visible ONLY if any of the yes/no fields contain a yes (showing as a check in the checkbox). I tried an if then statement like this:
If Field1 ="no"...
No activity results to display
Leave a comment: