M
Martha Fulton via AccessMonster.com
I have created a data-entry database. The users 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 subforms which are
located on tabs under the primary report. On 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 Dashboard subreport (A) visible if
the “Dashboard Measure†box was checked on that tab; if “Onsite Review†box
is checked, then the Onsite Review subreport (B) should be visible in
the 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
I appreciate any assistance you can provide,
Signature
Martha
into the form that the database opens with. They will enter data into the
primary form (top part of the screen) and into 26 subforms which are
located on tabs under the primary report. On 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 Dashboard subreport (A) visible if
the “Dashboard Measure†box was checked on that tab; if “Onsite Review†box
is checked, then the Onsite Review subreport (B) should be visible in
the 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
I appreciate any assistance you can provide,
Signature
Martha