Thanks to help from this group I now have an option group on a from that
allows me to select which subform to display. The code to do that is list
below

Private Sub Frame51_AfterUpdate()
   Select Case Me.Frame51
       Case 1
           Me.EmployeeSubformcontrol.SourceObject = "Frm_EmployeePhone"
       Case 2
           Me.EmployeeSubformcontrol.SourceObject = "Frm_EmployeeCerts"
       Case 3
           Me.EmployeeSubformcontrol.SourceObject = "Frm_EmploymentData"
   End Select

End Sub

When I call the subform it returns all the data from the tbl. I would like
to limit the data to what is related to the Mainform. How can I add a where
clause to the above statement that would return the filtered information.

The Main form field is
Frm_EmployeeEditPage.QI

The subform’s field is

Frm_EmployeePhone.QINumber
Frm_EmployeeCerts.[QI Number]
Frm_EmploymentData.QI

Thank you