Matt,

You would have to hive it off somewhere, like a hidden worksheet or a text
file, and then the next time you open the form, re-in state it. All manual I
am afraid.

ans = MsgBox("Save the Form", vbYesNo)
If ans = vbYes
'call the save routine
Else
End
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matt" wrote in message
ups.com...
Good point Bob- Any idea of code that would allow the data to be saved
as well.

I'm also looking for a pop-up box which upon pressing the exit button
would ask the user if they wanted to save the form w/ data -- if yes
would save and if no would exit the entire application.

Thanks for everyone's help!