VB Forms: Do I have to code differently to place data on a Multipage (from toolbox) set on the second tab of another multipage?
I am using the VB Form Control Toolbox. I have placed a multipage on the form with five tabs. On the first tab I placed a multipage with six tabs.
On the second tab I placed a multipage with four tabs.
Where I need HELP:
I can not load data to the multipage that sets on the second tab of the first multipage.
The code used is:
'Placing data for Cost Update of Supply Management
SMCostTargetBox.Value = c.Offest(0, 47).Value
SMCostActualBox.Value = c.Offset(0, 48).Value
SMCostDifference.Value = c.Offset(0, 49).Value
SMToolingTargetBox.Value = c.Offset(0, 50).Value
SMToolingActualBox.Value = c.Offset(0, 51).Value
SMToolingDifference.Value = c.Offset(0, 52).Value
If c.Offset(0, 53).Value = "Yes" Then 'Service part Yes
YesOptionButtonAFEBudget.Value = True
ElseIf c.Offset(0, 53).Value = "No" Then 'Service Part No
NoOptionButtonAFEBudget.Value = True
Else 'No Entry for Service Part
YesOptionButtonAFEBudget.Value = False
NoOptionButtonAFEBudget.Value = False
End If
SMFactoryResponsibleforToolingBox.Value = c.Offest(0, 54).Value
SMEstimateorQuoteBox.Value = c.Offset(0, 55).Value
SMJune2003CostNet.Value = c.Offset(0, 56).Value
SMSept2003CostNet.Value = c.Offset(0, 57).Value
SMDec2003CostNet.Value = c.Offset(0, 58).Value
SMMar2004CostNetBox.Value = c.Offset(0, 59).Value
Am I trying to do something that can't be done?
Do I need to identify the location of the multipage...
UserForm1.Tab 2 of MultiPage1.MultiPage3 ????
Any suggestions are appreciated,
John
I am using the VB Form Control Toolbox. I have placed a multipage on the form with five tabs. On the first tab I placed a multipage with six tabs.
On the second tab I placed a multipage with four tabs.
Where I need HELP:
I can not load data to the multipage that sets on the second tab of the first multipage.
The code used is:
'Placing data for Cost Update of Supply Management
SMCostTargetBox.Value = c.Offest(0, 47).Value
SMCostActualBox.Value = c.Offset(0, 48).Value
SMCostDifference.Value = c.Offset(0, 49).Value
SMToolingTargetBox.Value = c.Offset(0, 50).Value
SMToolingActualBox.Value = c.Offset(0, 51).Value
SMToolingDifference.Value = c.Offset(0, 52).Value
If c.Offset(0, 53).Value = "Yes" Then 'Service part Yes
YesOptionButtonAFEBudget.Value = True
ElseIf c.Offset(0, 53).Value = "No" Then 'Service Part No
NoOptionButtonAFEBudget.Value = True
Else 'No Entry for Service Part
YesOptionButtonAFEBudget.Value = False
NoOptionButtonAFEBudget.Value = False
End If
SMFactoryResponsibleforToolingBox.Value = c.Offest(0, 54).Value
SMEstimateorQuoteBox.Value = c.Offset(0, 55).Value
SMJune2003CostNet.Value = c.Offset(0, 56).Value
SMSept2003CostNet.Value = c.Offset(0, 57).Value
SMDec2003CostNet.Value = c.Offset(0, 58).Value
SMMar2004CostNetBox.Value = c.Offset(0, 59).Value
Am I trying to do something that can't be done?
Do I need to identify the location of the multipage...
UserForm1.Tab 2 of MultiPage1.MultiPage3 ????
Any suggestions are appreciated,
John