Hello, let me see if I can explain this....
I have a report with a field in it that I can filter by. This field is called ManagerName. When I choose the manager I want and click on the email button at top of access I'd like the report to autoname to the manager I've chosen.
I don't have any forms or queries. 3 tables 1 report.
I see the caption field in the properties sheet view for the report, but how can I make it so that will change to the manager I've selected when I click on the Email button?
Is that possible?