I currently have a program that contains a template file. When the User starts a new project they input the project name. A script then creates a folder and a copy of the template to this folder and renames it the project name:

i.e. ....JohnsonJohnson.usr

I save the path and file name in global fields.

I had wanted to then open this new file without futher user input, but gave up on that. I am now just trying to have the Open File function open up in the new folder. I have tried all sorts of ways, to no avail. Can't get the default directory off the last opened table without user input. Any ideals?

Thanks

It's difficult to imagine circumstances that would warrant users creating a new file - especially when they cannot be trusted to open said file. Seems like you are utilizing spreadsheet methods with a database.

Why not simply have the user create a new record in the Projects table and continue from there?

The files are generated in "the field". The design has been in place for some time. Just tring to make it a little simplier. Users are certainly capable of "clicking" back one folder and then selecting the folder that was just created but would have liked to "spoon feed" them, if possible. I will take it that it's not an easy process. I was just hoping I had missed something. Thanks for viewing.