I have a 9 page multipage form. I want the user to be taken back to page one if an error is encountered on any other page. If I run the following code the highlighted page tab changes but the information from the page on which the error was encountered continues to be displayed. How do I get it to give up focus and display the information on the first page?
Please Login or Register to view this content.
See if adding
to the end of your posted code works.Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
If I add that code where txtObject is a text box on Page 1 I get this error 'Run time error 2110:'
"Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus"
Do you have a textbox or any other type of field on page 1?
Hi,
Which event are you running that code in? It won't work from the Multipage change.
Don
Please remember to mark your thread 'Solved' when appropriate.
Good point D...I hadn't thought of that.
Yes I am accessing and calling the various pages through the Multipage change event. Is there another way of doing this?
[code]
Private Sub MultiPage1_Change()
ElseIf MultiPage1.value = 1 Then
Call LoadSchedule
ElseIf MultiPage1.value = 2 Then
Call LoadBudget
etc...
[code/]
I would recommend hiding the tabs and using Next and Previous buttons to actually move through the pages. That way you can simply not move if a page is incomplete.
By the way, the tags are [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] rather than [code/]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks