Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Multipages in a Form
Hey all
I have just started using multipages in a form as I have heaps of info to extract. The problem is I do not know how to set the focus from one page to the next. I have field validations and when they trigger and the multipage is on another page I get a notinfocus error. I have these sort of validations: 'Checks if REFERRAL SOURCE is entered If Me.cbRefSource = "" Then MsgBox "Please enter the 'Referral Source'", vbInformation, mboxheader Me.cbRefSource.SetFocus Exit Sub End If and need to get the form to goto the page first. Please help - will be appreciated. Aaron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Multipages in a Form
You need the value property
mpInput.Value = 0 selects the first page. For readability when using a multipage, I also name each page in the properties window, and then use something like this With mpQuery If .Value = .pgCompanies.Index Then 'do something End If End With Robin Hammond www.enhanceddatasystems.com "Azza" wrote in message m... Hey all I have just started using multipages in a form as I have heaps of info to extract. The problem is I do not know how to set the focus from one page to the next. I have field validations and when they trigger and the multipage is on another page I get a notinfocus error. I have these sort of validations: 'Checks if REFERRAL SOURCE is entered If Me.cbRefSource = "" Then MsgBox "Please enter the 'Referral Source'", vbInformation, mboxheader Me.cbRefSource.SetFocus Exit Sub End If and need to get the form to goto the page first. Please help - will be appreciated. Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
MultiPages | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
Scrolling in Multipages | Excel Programming |