Thanks however it is a little more complicated than that. The form has a
subform also. There is no Y/N field and the developers wont add one to the
table. There is a print form button on the main form that does a ton of stuff
that I could add in the code but need the Y/N to make it work? Maybe add
another button or?

"Klatuu" wrote:

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?