Enabling Command Button

[anandvh]

Hi Everyone,

I am working on an application in which I use a multipage userform that has 5 pages. I have 4 command buttons titled BACK, NEXT, SAVE and CANCEL

CANCEL button is always enable irrespective of the page number that is active in the multipage userform.
BACK get enabled if the page no is not the first page
SAVE gets enabled if the page number is the last page instead of enabling the NEXT button
NEXT button gets enabled if the page number is not the last page

All the buttons other than the NEXT button function as desired. I am facing a problem with the enabling of the NEXT Page, which I try to explain below.

There are approx two mandatory fields on each page that need to be filled. When both these fields are filled, the NEXT button should get enabled. This works fine when a blank form is being filled. The problem arises when I use the BACK button to return to the previous page that was filled earlier, the NEXT button should be enabled immediately since both the mandatory fields are already filled out. The code I am using for enabling / disabling the button is given below

Please Login or Register  to view this content.

while trying to rectify this bug, I observed that I have inserted the code in the "change" instance. This means that the code will be executed only if there is a change in the field. But I am not clear under which other instance I should insert the code so that it runs as intended.

Can someone help me with a solution to my problem ?

Thanks in advance for the efforts that you will all be putting in to help me.

Regards

Anand Hattangady

[mikerickson]

You add the line

Please Login or Register  to view this content.

to the Multipage Change event.

Although you might have to write an If ... ElseIf... End If to make sure that the Multipage Change is checking the correct controls for that page.

[anandvh]

thanks mikerickson'

Just implemented your suggestion of adding the call in the multipage change event. The NEXT button is behaving just as intended.