Multipage Error Handling

[John Petty]

I am trying to code some error handling for a Mulitpage
form, that checks to see if a certain form is active
before writing data. I would like to use the page names
instead of the page values (easier for another programmer
to work with).

I would like to code something like this

If Multipage1.name <> "PageRelease" or MultiPage1.Name _
<> "PageChange" then
MsgBox("You must have an EO Form Active to use this _
Wizard" & vbCrLf & "Please open an EO Form and _
try again")
Exit Sub
Else
My code here

Any suggestions?

Thanks for your help

John Petty

 

[Robin Hammond]

John,

I do something like this with the same intent. The name for this page is
pgCompanies.

With mpQuery
If .Value = .pgCompanies.Index Then
'do something
end if
end with

Robin Hammond
www.enhanceddatasystems.com