sportsguy
Finance wiz, Access hack
- Local time
- Today, 04:09
- Joined
- Dec 28, 2004
- Messages
- 363
Those still keeping the genius title,
I have a basic report which runs based upon a couple of drop down boxes from a form. The report runs fine, but what I want to do is to update the report Caption prior to printing so that the print to PDF will have the correct file save as name, and I don't have to rename the report each time.
The caption needs the fiscal year and period, the calendar month, the Operation or region number, the operation or region name, and then the report name.
If you have any suggestions, I will be willing to explore them, but so far, i haven't been able to figure it out. . .
thanks in advance,
sportsguy
I have a basic report which runs based upon a couple of drop down boxes from a form. The report runs fine, but what I want to do is to update the report Caption prior to printing so that the print to PDF will have the correct file save as name, and I don't have to rename the report each time.
The caption needs the fiscal year and period, the calendar month, the Operation or region number, the operation or region name, and then the report name.
If you have any suggestions, I will be willing to explore them, but so far, i haven't been able to figure it out. . .
thanks in advance,
sportsguy