ACC2000: Access Methods That Reset The Visual Basic Project

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. Create a module and type the following lines in the Declarations section:

   Option Explicit
   Public pMyVar As String
   					

3. Type the following procedure:

   Sub CreateNewProc()
       Dim frm As Form
       Dim mdl As Module
       Dim ret As Long
   
       'Set Public Variable.
       pMyVar = "Hello"
   
       'Create a new form.
       Set frm = CreateForm()
       Set mdl = frm.Module
   
       'Create an event procedure in the form's module.
       ret = mdl.CreateEventProc("Load", "Form")
   
       'Display current contents of Public variable.
       MsgBox "pMyVar = " & pMyVar
   End Sub
   					

4. To test this procedure, type the following line in the Immediate Window, and press ENTER:

   CreateNewProc
   						

   Note that a form is created with an event procedure, followed by a message box that contains the contents of the public variable.
5. After the procedure has completed, type the following in the Immediate Window, and press ENTER:

   ?pMyVar
   						

   Note that the public variable is reset and now contains an empty string.