>>>It didn't work.........any other way?
>>Renel,
>>
>>What does "it didn't work" mean? Was there an error, did the wrong table get opned?
>
>
>Jim
>
>It opened the wrong table. I already
>did this "THISFORM.DATAENVIRONMENT.CURSOR1.DATABASE = "K:\TEST\1997.DIR\TMPDB.DBC"
>
>When I created my form I used the 1996.dir for my tables, but then I want to use
>another directory w/c is 1997.dir, unfortunately it gets always the 1996.dir.
Renel,

This code must be in the OpenTables event of the DE in order to work, anywhere else and the tables are already open when you change the database.