closing forms, how?

[uttam1]

Hi all,

I have a command button "Done". When it's clicked, I want the form to close ( not hidden ), and open another form. How do I do this?

Thanks in advance
-Uttam

 

[airtabaki]

You can use a macro: close and then specify that it is a form you want to close and wich form you want to close of course... or you can use the commando unload me to close a form. To open a form: load [formname]

 

[TonyJollans]

Hi uttam1,

I always find it a bit odd that code inside the unloaded form still runs but what you need is ..

Unload Me
NewForm.Show

Enjoy,
Tony

 

[uttam1]

Hi airtabaki, TonyJollans,

Thanks for the replys! I tried using Unload Me, but I get an error saying you cant unload the object (?). I tried the macro and it worked perfect! Thanks a ton!

-Uttam

 

[TonyJollans]

Hi uttam1,

My apologies! I was in Excel mode. Glad you got it sorted with airtabaki's help.

Enjoy,
Tony