unload form

[Kennethj]

one of my forms in my project wont reappear after unloaded the last form.

'This wont work
unload game (second)
startup.show (first)

'i need to:
unload startup
and then
load startup again!!!
startup.show

this will return back to windows GUI and then to startup form.
Annoying.
i thought i needed just to unload game, and the startup would reappear. why doesnt it reappear?!

[Hack]

1. It should be

Startup.Show

, not show startup

2. It sounds like Startup is unloaded when Game is loaded. This means that when Game is unloaded, Startup will have to be implicited loaded again, unless you have the Startup.Show in the unload event of the Game form.

[Kennethj]

spelling mistake sorry. i have corrected it on my first post. Any who knows why it happens?

My game has two forms.
(The first loaded is Startup.frm then game.frm)

why dont this work:

unload game
startup.show
(project freezes)

need to do this: (annoying) Switching back to Windows GUI!! then back on to startup.

unload game
unload startup
load startup
startup.show

[Hack]

Is there anything in the Game form unload that might conflict with something in the Startup form load?

[Kennethj]

difficult to say, i would have to show you the whole code, but i havent internet at home where my files reside.

[Hack]

Based on what you presented, I can find nothing wrong. Without seeing exactly what these two forms are doing, it is difficult to recommend a course of action. If you could display the Form_Load and Form_Unload of BOTH forms, that might help.

[spyplayer]

THE FORM WONT LOAD OR IT JUST FREEZES..?

wouldn't you

startup.show
unload game

?

I dont get what you want... ohhhh well...

Have a nice day!

[Kennethj]

i havent used form_unload in any projects, and i didnt seem to need them. they worked properly. but maybe i need to do it in this project.

Give me an example of a code using the form_unload please.

[Hack]

Unload is typically used for housekeeping chores like closing databases, recordsets etc. and clearing out variables, and closing all forms. Here is a typical Unload event for me.

Private Sub Form_Unload(Cancel As Integer)
    On Error Resume Next
    Dim i As Long
    'close all sub forms
    For i = Forms.Count - 1 To 1 Step -1
        Unload Forms(i)
    Next
   'close database and recordset objects
   Db.Close
   Set rs = Nothing
   Rs.Close
End Sub

[Kennethj]

sub forms, do you mean all forms loaded after the first one?

in my project startup is loaded at first.
So i use your form_unload code to close all forms, but it will not affect startup.frm. is that correct?

[Kennethj]

when implementing your unload_form code i receive an error
Private Sub Form_Unload(Cancel As Integer)
On Error Resume Next
Dim i As Long
'close all sub forms
For i = Forms.Count - 1 To 1 Step -1
Unload Forms(i)
Next
'close database and recordset objects
Db.Close
Set rs = Nothing
Rs.Close
End Sub

The db and rs is not defined.

[Hack]

Db and Rs won't be defined unless you define them. Those two are created by me to refer to my database object and my recordset object. If you have other variables assigned for these functions, or you are not using a database or recordsets, then you don't need to close them when the form is unloaded.