Check boxes selecting reports on conditions

  • Thread starter Thread starter beavray
  • Start date Start date
B

beavray

The idea I need to bring to life is;

On a Form connected to a Subform, that is connected by Project ID,
the user has to select from report check boxes as many reports tha
they want for the Project record that is visible on the current for
and subform. When I created a macro to open each report with an I
statement,(If Check box = True) It will open the first report but fo
each after it pops up a perameter box asking for the Project ID for th
next report. What do I use in the Macro to be able to open up anothe
report on the same Project record
 
If each of the potential reports is ONLY opened from this form, then you can
add the field on the form that holds the ProjectID as a criterion into the
source definition of each report. Then, when the report(s) open, they use
the form's ProjectID value.

The downside is that the reports REQUIRE the form to be open and a project
(ProjectID) to be selected.
 
Back
Top