>I am trying to generalize an existing application. I have removed almost all of the hard code references to specific folders (directories). The one item left is refrences to free tables which are in the project. Thus in the DE the control source for these tabales is the folder I am using for development. The simplest solution if it can be done would be to change the control source of the table at run time (bad news this occures in two most complicated forms with most tables in them, good new it is only one table in each form). My question is if it can be done where is the best place to do it and is the correct syntax
>
> formname.controlsouce = gcfoldername + 'tablename'
>
>where gcfoldername is a global varibale which is the name of the folder where table resides (i.e. c:\localworkfolder, I am using a global variable because it already exists)? If not what is the correct command (assuming it can be done)?

Yes it can be done and yes that is the correct format. I do something similar for all tables/view etc and I have placed the code in the DE BeforeOpenTables event. (Don't forget to make sure there is a backslash between the path and table name if its not part of the global var AddBS())

HTH