conditional format tab control pages

  • Thread starter Thread starter Walter
  • Start date Start date
W

Walter

I have a form with a tab control which contains several subforms. I would
like to highlight the pages which contain data. I think I'll have to hide
any pages on which the subforms are blank. I know I need to test the
subforms, ie.
For each subform on mainform
If IsNull subform1 then
page0.visible = False
End If
Next subform
How do I reference these from the main form?
 
Walter said:
I have a form with a tab control which contains several subforms. I would
like to highlight the pages which contain data. I think I'll have to hide
any pages on which the subforms are blank. I know I need to test the
subforms, ie.
For each subform on mainform
If IsNull subform1 then
page0.visible = False
End If
Next subform
How do I reference these from the main form?
Click to expand...

Although the subforms are on different pages of a tab control, they are
members of the form's controls collection, so the syntax is:

For Each ctl In Me.Controls
If TypeOf ctl Is Subform Then
If IsNull(ctl.Form!ControlName) Then
Me.TabControlName.Page(n).Visible = False
End If
End If
Next

Untested, but that ought to be somewhere close..
 
Back
Top