dependent button

[ariansman]

it worked. thank you very much. i assume the phrase "vbNullString" is not necessary here. right?

[ariansman]

can you also advise me what if there are lots of textboxes, for example 10 texboxes. in this case shall we run the code from the after update of every single textbox?

[pbaldy]

If you want it to respond to all of them, it needs to run from all of them. As I mentioned originally, I'd create a function and call it from each of them. That way the code is only in one place.

[ariansman]

well, a form can have too many textboxes and it can be very exhastive to make an afterupdate for every one of them.
i am not a programmer but seems to me there should be a way that the button checks for something before getting activated.

[pbaldy]

Well, rather than toggle the enabled property of the button, you could simply put code behind the button to test if all the textboxes are filled out, and give the user a message box instead of going to the second form if not.