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 suggestion on how to make it work?

I thought I answered this in one of the forums. The Tab Control should not make any difference. The WhereCondition argument of the OpenForm command simply puts a filter on the MainForm. If you have SubForms on your tab control, they are not directly addressed except through the LinkChild/MasterFields properties of the SubFormControls.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"