M
Martha Fulton via AccessMonster.com
I see this issue addressed several times on the “Access Monster†website, but
I am unable to understand what the instructions mean. I am a relatively new
Access database designer and I have no programming training or experience and
VERY LITTLE experience with macros or the other more intricate aspects of
Access.
I have created a data-entry database for a coworker. The user will enter data
into the form that the database opens with. They will enter data into the
primary form (top part of the screen) and into 26 subreports which are
located on tabs under the primary report. EACH of the 26 subreports (tabs),
the user must select one or both of two check boxes: “Dashboard Measures†or
“Onsite Review.â€
In the final report, I need the related Dashboard subreport (A) visible if
the “Dashboard Measure†box was checked on that tab; if “Onsite Review†box
is checked, then the related Onsite Review subreport (B) should be visible in
my report; and if both boxes are checked on the form, then both subreports
should be visible in the report. Currently I have both subreports added to
the report, but I can’t figure out how to tell them when to be visible and
when to be hidden.
Perhaps it would help if I give you the following example:
Name of Report: Final1-Safety1
Name of SubReportA: R-05-Dash
Name of SubReport B: R-05-Onsite
Name of Form: F-05-FCReEntries
Name of Box A: DashboardMeasures
Name of Box B: OnSiteReview
Thank you for your assistance,
I am unable to understand what the instructions mean. I am a relatively new
Access database designer and I have no programming training or experience and
VERY LITTLE experience with macros or the other more intricate aspects of
Access.
I have created a data-entry database for a coworker. The user will enter data
into the form that the database opens with. They will enter data into the
primary form (top part of the screen) and into 26 subreports which are
located on tabs under the primary report. EACH of the 26 subreports (tabs),
the user must select one or both of two check boxes: “Dashboard Measures†or
“Onsite Review.â€
In the final report, I need the related Dashboard subreport (A) visible if
the “Dashboard Measure†box was checked on that tab; if “Onsite Review†box
is checked, then the related Onsite Review subreport (B) should be visible in
my report; and if both boxes are checked on the form, then both subreports
should be visible in the report. Currently I have both subreports added to
the report, but I can’t figure out how to tell them when to be visible and
when to be hidden.
Perhaps it would help if I give you the following example:
Name of Report: Final1-Safety1
Name of SubReportA: R-05-Dash
Name of SubReport B: R-05-Onsite
Name of Form: F-05-FCReEntries
Name of Box A: DashboardMeasures
Name of Box B: OnSiteReview
Thank you for your assistance,