file path in footer

[prmitchell]

Hello
In Access 2010 how to add a file path in the report footer?

thx

 

[Minty]

File path to what exactly?

(Mind reading skills are often weak on a Tuesday)

 

[prmitchell]

path to the accdb file

 

[Minty]

Blatantly looked up in Google from MS;

MsgBox "The current database is located at " & Application.CurrentProject.Path & "."

 

[prmitchell]

thank you Minty