ok maybe i'm just confused.. your subject line says workbook.. and sounds like
your either switching workbooks or worksheets.. but your saying form... if
it's a form.. where is the form  1 getting its information and then your
dynamically creating form 2 ... i'm lost why you would be doing this from forms
instead of where your getting the data  from.

if your talking workbooks.. then you can just use a variable  and before you
switch to the second workbook.. just save that filename...

dim mybook as string

mybook = activeworkbook.name (or thisworkbook.name)
workbooks.add
paste or what ever then

workbooks(mybook).activate

that'll bring you back to the first workbook.

of course like i said i'm confused at what your trying to do.. so i may be way
off