Make subform visible or not in report?
So who is supporting you now?
--
Dave Hargis, Microsoft Access MVP
"TKM" wrote:
Wish I could but he died last year!
"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?
|