Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Fri May 7 13:13:11 CDT 2004
Microsoft recommends this procedure. Any common practices that deviate from this method? 1. Create an empty form. 2. Declare a recordset variable in the global declarations section. 3.In the OnOpen event, open a recordset against any table. 4. In the OnClose event, which will activate when the MDB is closed, close the recordset and set the variable to nothing. 5. Ensure that you always open this form when opening the MDB. You will likely want to have this form hidden when you open the file. Mark