Tab Control Pages

[queenbee]

I am using the following code that works!

Private Sub NoticeID_Click()
On Error GoTo Err_Notice_Click
Dim FormName As String


Dim LinkCriteria As String

FormName = "NoticeDetail"

LinkCriteria = "[NoticeID] =""" & Me.NoticeID & """"

DoCmd.OpenForm FormName, , , LinkCriteria
Exit_Notice_Click:
Exit Sub
Err_Notice_Click:
MsgBox Err.Description
Resume Exit_Notice_Click
End Sub

I am experiencing a problem when I change FormName to a TestForm with tab control pages, the data is not filtering into the TestForm. Any suggestions on how to make it work?

[RuralGuy]

The WhereCondition argument of the OpenForm command puts a filter on the RecordSource of the form being opened. It does not care if there is a tab control on the form or not.