You can use the Open event of the report to read the value in a control on
the form from which you launch the report and make the sub report control on
the report visible or not. This example uses a check box where checking the
box makes the comments visible.

Me.subComments.Visible = Forms!FormName!chkShowComments
--
Dave Hargis, Microsoft Access MVP


"TKM" wrote:

I messed up. I need to make the comment either print or not print. As I
stated it is embedded as a subform in the report based off its own query. Any
help would be appreciated.

"TKM" wrote:

I have a subform in my report list all the comments associated with a loan
number. I am looking for a why (in my query?) to hve the Comments print or
not print depending what the user wants. I dont not have a Y/N box set up for
this. Is there a way in my query I can do this?