>Hi,
>My application uses a free table like HINAMES.DBF. My users can put their tables anywhere on their network. So I store the Path to the data in another table and get the path when the App starts:
>mPath=MyTable.Path value="c:\data\"
>Then, I set a variable to the whole path of the free table:
>mDBFnames=mPath+"hinames.dbf"
>Therefore, mDBFnames = "c:\data\hinames.dbf", and I open the table like this:
> select 1
> set excl off
> use &mDBFnames
>This code is in the Init event of my form, but wont open the table. I keep getting a:
>Error - ControlSource - Record No 5. Alias 'HINAMES' not found.
>
>I dont want these tables in the form's Data Environment because it stores the physical path of the table during development and I cant find any way around it.
>
>Does anyone know any tricks for either the Init code or taking the path out of the Data Environment?
>Thanks, John Morga

Put the code to open the table in the load of the form.