Clearing off forms

[Audiojoe]

Hi, I'm pretty new to VBA and am currently making a userform. When I click a button at the bottom of my form to submit the info another form comes up saying would I like to go to another form, but if I say yes, the little form that asks me that stays there. I need it to disappear once it's done it's job.

How do I do this?
This message was edited by Audiojoe on 2002-02-28 05:37

 

[Mudface]

In the button's Click event, put this at the end-

Private Sub CommandButton1_Click()

UserForm2.Show
Me.Hide

End Sub

 

[Audiojoe]

Superb! Thanks man

 

[Mudface]

Actually that should be-

Me.Hide
UserForm2.Show

Sorry

 

[Audiojoe]

Ah yes, that's better

 

[Audiojoe]

Ah yes, that's better