>Cetin,
>
>I'll run you through what my program does on start.
>
>- loads the form
>- once the form is loaded, it transfers a snapshot of table onto the users HD to have local access to create reports for specific depts, groups and projects
>-when the program is closed, the snapshot is deleted from the HD
>
>I'm trying to figure out a way to transfer the data, after the form has loaded
>(nothing to do with my cboxes).
>
>I tried it in the init method but it still seems to be too early in the startup process
>
>perry
Perry,
For SQL you could do it anytime. But if you're using the table in your form you should do it in load or init (I prefer init). And after doing it you also must be sure the form is using that table (ie: You have form.dataenvironment and form objects that use those DE.tables as controlsources - DE.table paths are hardcoded and should be changed to refer to new local table). That might be the problem. Consider using views or cursors also.
Cetin