If you are using data environments check that the auto close property is not set to True. If it is the tables in the data environment will be closed when the form is released.
John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic > Sent: 02 January 2007 18:19 > To: [EMAIL PROTECTED] > Subject: Saving and restoring data environments - and variables > > > Hi all, > > In this project I'm working on, my users wanna be able to have > several forms > open at once. For example, if they're in the Finished Goods > form, they may > wanna open up the Customers form. If I open the Customers form and then > close it, when I return to the Finished Goods form, the tables are closed. > > What do I need to do to save the current environment when opening another > form on top of one that's already open so I don't lose those open tables? > I've looked at a number of things in the Help, but nothing I try seems to > work. Are there any particular settings I need to look into? > > Also, I have two variables I use in each form to keep track of whether or > not I'm in adding mode or edit mode. They're called Adding and Editing. > When I open that second form then close it to return to the first form > (which is still open), I lose Adding and Editing since I release them when > closing each form. I've looked into Public, Private and Local, but am not > seeing the proper way to keep my Adding and Editing variables alive and > unique to each form I have open. What do I need to look for there? > > Thanks very much! > > John > "The difference between a successful person and others is not a lack of > strength, not a lack of knowledge, but lack of will." - Vince Lombardi > > * All mail scanned by Norton AntiVirus. No AV software on your computer? > Remove me from your address book, please. > > * Please respect my privacy. Do not forward my address to anyone else or > include me in emails sent to multiple recipients. Use BCC. > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
