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)?