hi,
I have posted this up in the Forms section but received no reply so I'm going to try it here.
I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed.
thanks.
My idea so far (which doesn't work is): The first statement is also true.
Private Sub cmdPrintModule_Click()
Dim tbtab As Page
For Each tbtab In Tab1.Pages
If tbtab.Name = Me.Tab1.Pages("General").Name Then
Call PrintGeneral
ElseIf tbtab.Name = Me.Tab1.Pages("Piping").Name Then
Call PrintPiping
End If
Next
End Sub
Edit/Delete Message
I have posted this up in the Forms section but received no reply so I'm going to try it here.
I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed.
thanks.
My idea so far (which doesn't work is): The first statement is also true.
Private Sub cmdPrintModule_Click()
Dim tbtab As Page
For Each tbtab In Tab1.Pages
If tbtab.Name = Me.Tab1.Pages("General").Name Then
Call PrintGeneral
ElseIf tbtab.Name = Me.Tab1.Pages("Piping").Name Then
Call PrintPiping
End If
Next
End Sub
Edit/Delete Message