HELP! Display Filename in Footer

[Guest]

I am trying to get my Access 2002 reports to display the report name on the
footer.

I have tried (1):
=CurrentDb.Name

and also tried (2):
="Report Name: " & Screen.ActiveReport.Name

Option (1) inserted the file path, not the name.
Option (2) inserted the name, BUT only when I already have the file open in
design mode. Opening the report through the Reports Switchboard (or any other
way) causes the report name to read as #Error.

How can I display these reports in my footer when they are printed?

 

[fredg]

I am trying to get my Access 2002 reports to display the report name on the
footer.

I have tried (1):
=CurrentDb.Name

and also tried (2):
="Report Name: " & Screen.ActiveReport.Name

Option (1) inserted the file path, not the name.
Option (2) inserted the name, BUT only when I already have the file open in
design mode. Opening the report through the Reports Switchboard (or any other
way) causes the report name to read as #Error.

How can I display these reports in my footer when they are printed?

=CurrentDb.Name returns the path and name of the database.
="Report Name: " & [Name] returns the name of the report.

 

[Fons Ponsioen]

I have done it with "=Name" in a textbox