Tab Control and Recordsource

[gmaster]

Hi, i have a form with a tab control and i need it to change its record source when i click on the label and change the tab.


Now, i've tryed using VBA's command "Me.RecordSource= " but it only works when i click on the boby of the tab and not on its label...is there a way to do it??

[ItsMe]

In earlier versions of Access, clicking the tab did not do anything. I do not suggest using the Page's click event but when creating a tab control in 2010 and using a tab control in 2010 you can fire code like the following when clicking the Tab Control.

Private Sub tabTest_Click()
Dim intTab As Integer
intTab = Me.tabTest.Value
    Select Case intTab
    
    Case 0
        MsgBox "1"
    
    Case 1
        MsgBox "2"
    
    Case 2
        MsgBox "3"
    
    Case Else
        MsgBox "Error"
    
    End Select
End Sub

Another option is to use the On Change Event to fire the code. This works on earlier versions as well.

As for the recordsource thing. I am not aware of the tab control, itself, having a recordsource property.

[Missinglinq]

...when creating a tab control in 2010 and using a tab control in 2010 you can fire code like the following when clicking the Tab Control...

You mean the Boys of Redmond made a change that actually made things better, instead of making things worse? Who'd have thunk it?

...I am not aware of the tab control, itself, having a recordsource property...

Me, either! I suspect the OP has a Subform on the Tabbed Page, but we really need a clarification on this.

Linq ;0)>