Selection Macro for Running a Report

[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.

 

[KARL DEWEY]

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.