![]() |
Multipage Error Handling
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 |
Multipage Error Handling
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 "John Petty" wrote in message ... 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 |
All times are GMT +1. The time now is 12:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com