Report! Code needed to Hide a Reports Detail Line

G

Guest

I have a series of reports that share a single filter form that allows the
user to select several different fields to filter the reports on. One of the
comboboxes is for details or summary. If they select summary I want to hide
the detail line of that report. The problem I am having is how to put a
varible name into a Report! statement? I have tried the following:

Report!stDocName.Detail.Visible = False

where stDocName is varible that holds the name of the report. This form is
opened when the report is opened. In the past I have put a message box in
each individual report and it works fine. I am just trying to streamline.
Please help!
 
M

Marshall Barton

DDBeards said:
I have a series of reports that share a single filter form that allows the
user to select several different fields to filter the reports on. One of the
comboboxes is for details or summary. If they select summary I want to hide
the detail line of that report. The problem I am having is how to put a
varible name into a Report! statement? I have tried the following:

Report!stDocName.Detail.Visible = False

where stDocName is varible that holds the name of the report. This form is
opened when the report is opened. In the past I have put a message box in
each individual report and it works fine. I am just trying to streamline.
Click to expand...


Reports(stDocName).Detail.Visible = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How would i refer to a closed report? 8
Hide detail section 7
Summary Report - Ability to Drill Down a line Item Detail 4
Cancel a Report from a form 7
Exporting a Report to Excel 2
Hiding a window when a report opens 3
Pass Subform filter to subform in report 0
Applying a Filter to a Report 1

Top