Full Version: Runtime Error 430 When Working With Multipage Fields
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
pg123
I am trying to run the If/Then statement below as a Click event on a button in a userform containing a multipage object, and I'm receiving a run-time error 430.

Dim FrameInfo as String

If MultiPage_ConnectDirect_Connection.Pages("Data_ConnectDirect_Frame_Contact").Value = "" And _
MultiPage_ConnectDirect_Connection.Pages("Data_ConnectDirect_Frame_Phone").Value = "" And _
MultiPage_ConnectDirect_Connection.Pages("Data_ConnectDirect_Frame_Email").Value = "" And _
MultiPage_ConnectDirect_Connection.Pages("Data_ConnectDirect_Frame_HostIP").Value = "" Then
FrameInfo = "NotStarted"
End If

The Excel file was created in this install of Office 2010, I am not calling any outside database, and I have no dll references. In short, I'm not doing any of the interesting things that seem to be the common causes of this particular error. Anyone aware of other possible causes?

pg123
OK, I think the issue is I'm not paying attention. I need to reference the field within the page, and I'm only referencing the page within the multipage. So now I've identified my problem, I just need to go figure out the correct syntax.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.