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?