InputBox ...

When I click on the Button1 of The Form1, The Form2 appear. I have to enter a value in a textbox of the Form2. How can I stop the code executing in Form1, while I am entering a value in TextBox of Form2?

I want to personnalize my form, that's why I don't want to use the "InputBox".

Any Help will be Appreciate.

 

[blweb]

I think we need a bit more information here. Are you trying to get rid of Form1 when you hit the button and it loads Form2? If so then throw "Unload Me" after Form2.show. That will stop the code in Form1 from running. Otherwise you can hide the form or leave it sit while Form2 is running. If you don't want any actions to be performed by the user on Form1 while you are in Form2 then you need to do Form2.show vbmodal. This will make Form2 the only form that can be delt with by the user.

I hope this helps,
blweb

 

[chiph]

Use vbModal in the call to Form2.Show

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first