Selection Macro for Running a Report

  • Thread starter Thread starter Pjdelchi
  • Start date Start date
P

Pjdelchi

Alright, I need some help with this one. I have a report that lists
salesman and their sales for the month. I wouild like to be able to select
which salesman will be included in each daily report. I envision using a
form which pops up and I can check which salesman to include in each days
report but I am not sure how I should go about setting this up. I would
like to just click on the report, have the form pop up and have the report
print after I check which salesmen to include. In the future, I would also
like to have each of these reports emailed to the salesmen instead of printed
so any thoughts that you have on this would help too.

Thanks you guys.
 
Have form with subform that is not linked.
The main form have a couple of buttons - Select All; Unselect All; Run Report.
Select All - runs macro to update salesmen table checkboxes to -1 (minus
one, checked).
Unselect All - runs macro to update salesmen table checkboxes to 0 (zero,
unchecked).
Run Report - run report with criteria in query for checkbox equal -1.

The subform in continous view listing the salesmen and a checkbox. Check
off individual salesmen if not want all.
 
Back
Top