In Access 2003 I used the following command within the report Activate Event to change the default directory...
Application.SetOption "Default Database Directory", gstrReportsDirectory
...where gstrReportsDirectory is a global variable containing the required directory name.
Then, with the...