Help in closing or unloading forms 1

[Micash]

Could someone please tell me how to effectively ensure that all my forms are unloaded when I unload my front end/main form in a log off procedure?
Much obliged - Micash

 

[dpaulson]

Put this in the Form unload event in your front end/main form .


Dim frm As Form
For Each frm In Forms()
If frm.Name <> Me.Name Then
Unload frm
End If
Next
Unload Me

David Paulson

 

[Guest_imported]

Don't forget to set them to 'Nothing':

Dim frm As Form
For Each frm In Forms()
If frm.Name <> Me.Name Then
Unload frm
SET FRM=NOTHING
End If
Next
Unload Me
SET MAINFORM_NAME=NOTHING
Marc

 

[DJTN]

Set form1 = NOTHING
Todd Norris
Hope this helps !

 

[dellyjm]

I have a question. Will this work when not using MDI forms.

Delton Phillips.
New Generation Solutions
ngs@cwjamaica.com
deltonphillips@hotmail.com

New Thinking...Better results.

 

[madlarry]

dellyjm,

Yes, it will work because the Forms collection is an instrinsic collection that contains all of the 'currently loaded' forms. It is not limited to MDI applications.

Madlarry

 

[dellyjm]

Thanks.