Never use the End statement

Never use the End statement

There are a lot of risks involved in using End in VB programs: your databases might not be correctly closed, your objects are not correctly terminated, etc. You should always terminate a program by unloading all the forms. You can do this using the following routine:

For index = Forms.Count - 1 To 0 Step -1  Unload Forms(index)Next

or you can use a Do While loop:

Do While Forms.Count > 1  Unload Forms(0)Loop

UPDATE: The above code doesn’t unload the form from which it is lanched. To effectively unload all forms, add an Unload Me statement.


Share the Post: