I understand.
The solution I proposed will work. To recap:
1. Add a checkbox control to the form the combo is on that the report is run
from.
2. Add the following code to the Open event of the report. (you will have to
use the correct names)

If Forms!MyFormName!MyCheckBoxName = True Then
Me.MySubReportControlName.Visible = True
Else
Me.MySubReportControlName.Visible = True
End If

Or more simply stated:
Me.MySubReportControlName.Visible = Forms!MyFormName!MyCheckBoxName

Now one thing to note. You don't use the name of the report that is the
subreport. You use the name of the control on the report that contains the
report object that is the Source Object of the the control. If you let
Access do it, they are likely the same. You just need to look at the report
in Design View and open the properties dialog for the subreport control to
get the correct name.

Get some rest and hit it tomorrow.
--
Dave Hargis, Microsoft Access MVP


"TKM" wrote:

I am tired as heck as I have 11 tickts I am trying to clear up. Dont mean to
sound so dumb about this but here is how it goes. The user selects the report
he wants from a cbo. the report then opens and the user will print the report
in front of her directly using the menu. Now all want is some way for the
user to have an option to print or not print the comeent section on the
report. Your past answers will they take care of this? I am very tired 12
hours and pushing it. Thanks for all your help!

"Klatuu" wrote:

You don't need a Y/N field in your table. You just need a checkbox on the
form. That way when a user checks the checkbox, the comments will show.

Step two:
Slap the crap out of your lazy developer.
--
Dave Hargis, Microsoft Access MVP


"TKM" wrote:

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?