How to close a userform 1

[AncientTiger]

This SHOULD be simple, but how do you CLOSE a userform using script, instead of just hiding it?? I've tried myuserform.close, and myuserform.terminate.... both don't work....

 

[capitano]

Try Me.Close()

This works in VB.NET anyway.

Bryan

 

[AncientTiger]

Nope..... VBA didn't like that at ALL..

 

[mtnsurfer22]

try calling the method instead of the action...

DoCmd.Close [objecttype, objectname], [save]

objecttype is an intrinsic constant (probally acForm for you)

the default constant acSavePrompt is initiated if the the save argument is left blank but you could also use acSaveNo or acSaveYes depending on what you want to do.

if this is the default or active form that you are closing then you can leave all those arguments blank and just go with DoCmd.Close

Eric

 

[AncientTiger]

There is no close method for a userform...

 

[uberpudge]

To close a userform in VBA, I use the "Hide" method and the "Unload" keyword.

Example:
UserForm1.Hide
Unload UserForm1

Hope this helps,
Pete

 

[AncientTiger]

BY JOVE! I do believe that's got it!!

Thanks a ton uberpudge!

 

[mtnsurfer22]

sorry...your right...

Have you tried to 'unload' it. I am fairly sure there is a .unload statement that removes it from memory.

eric