I put some time into making this work today. Here is what I have so far:
Private Sub Add_Comments_Click()
Dim EmployeeIDFilter As Integer
Me.txtEmployeeIDFilter.Value = EmployeeIDFilter
DoCmd.OpenForm "Client Main Form", acViewForm, , "ClientID = " & Me.txtClientIDFilter...