New to Forms-How cancel Multipage change page event?

[mc84excel]

I am just trying to create my first MultiPage.

On page change event, I want the data on page 1 to be validated (I have the validation checks working).

If any of the validation checks fail, I want the page change event cancelled. However I can not find a way to cancel this.

An equally acceptable solution (if unable to cancel the change event), would be to force the multipage back to the first page.

Can this be done?

[JosephP]

don't attempt to cancel it. if you need that I suggest you hide the tabs and use your own controls-buttons, labels and whatnot-to advance the tabs. you can then enable/disable the controls as appropriate

[mc84excel]

Thanks for the suggestion Joseph. (I will probably end up using this). But I'm still curious - is there no way at all to either a) cancel the multiform page change or b) on change, force the user back to the first page?

I have tried doing b) with no success:

Please Login or Register  to view this content.

But all the above code does is change the selected tab at the top of the multiform. It doesn't change the displayed page back to the first page. What am I doing wrong?

[JosephP]

nothing-it simply doesn't work well which is why I said don't attempt it ;-)

[mc84excel]

This is one of those times when I wish VBA did what I want it to do rather than having to work around its limitations. Oh well. +1 for your alternative of hiding tabs & using buttons - I will do this instead.