Report As of date name

K

KAnoe

I would like to have the the report name with the date it was run. I know
that when you export the report it will have the name that is listed in the
properties/Format/Caption for that report. So if it is the daily report the
name of the doc will be daily report. I would like to have it add the date
that the report was run. so it would save the Doc as Daily report for 1 Jan
05.

Thanks
 
D

Duane Hookom

You could try change the caption of the report in the On Open event of the
report:
Me.Caption = "Daily report for " & Format(Date(),"d mmm yy")
 
K

KAnoe

Duane, it did not work. I did it as you said and the report file was Daily
Report. That is the Report name.
 
Top