getting there from here

[markjkubicki]

Can code be written so that, when the user opens a particular *.mdb, a second (unlinked) *.mdb is then alos opened, some lines of code in that second *.mdb are ran, and then the original *.mdb, that the user first opened, is closed (while leaving the second acvtive?)

any thoughts, directions, <etc> will be greatly appreciated
thnx
mark

[weekend00]

1 setup STARTUP form (e.g. form1) in the particular .mdb;
2 in the form_load event of form1, open the second .mdb;
3 setup STARTUP form (e.g. form2) in the second .mdb;
4 in the form_load event of the form2 of second mdb, close the first mdb;

[markjkubicki]

is there a way to pass to the second the file name of the first, so that it knows what file (it could be 1 of many) that is ought to close?

[weekend00]

the better way is:
in the first mdb, after opening the second mdb, close itself.