Forms

EA510BD0-8193-4A50-9EAC-58C4C883D722 — Wed, 11 Jun 2008 23:45:49 GMT

I am creating a macro for entering a new individual consitutent. Unfortunately the only reference I have found so far to Forms in the RE VBA esentials guide is on page 98, where it indicates that "VBA provides full-featured forms design support", where I "can design a custom data entry form". It does not however, explain how to do this. After much reseach, trial, and error I have found that I must start the macro with the following code in the module named "User_Macros":

Public Sub AddNewMember()

Load frmNewMembers
frmNewMembers.Show

End Sub

Where "AddNewMember" is the name of the macro. Now my macro is being terminated as follows:

Private Sub cmdExit_Click()

    moCodeTablesServer.Closedown
    Set moCodeTablesServer = Nothing

    End

End Sub

This is taking place in the form, not in the original User_Macro module. The "Closedown" and "Nothing" lines are to shut down the Code Tables Server that I am using to load a combo box -- it took me quite awhile to figure out how to do this also, especially since there was an error in the sample code. But I am wondering if I am going to end up with any memory leaks from not unloading the form? Is this done automatically as part of the "End" statement? I cannot figure out how to return to the original code and unload the form.

Search results matching tag 'memory leak'

Forms