Before running the report, prompt the user for the location of the files. Store that location in a variable. Follow the instructions on page 60 of my book and substitute your variable for the hard-coded path in the example.
Cathy
>Am using vfp 7.1 with Win XP home.
>Am building a report where the input tables can be in different directories, so need to have the ability to change the path to those tables at run-time.
>
>In Cathy Pountney's book on The Visual FoxPro Report Writer she says that you cn use the "Before Open Tables" Event (in the DE) when you need to change the path of the tables or view.
>I see how you can use the LocFile function to let the user determine the path where the tables are located, but how do you then open the tables from that location?
>All help appreciated.
>Bill Wright