Subquery in Form

[Jimbo]

I have a Form that the first tab includes the employee Id. In this
form the 2nd tab that shows a query for "Paid Time off"and the
3rd .tab that has shows query of state licensures.

I want the sub report to pull only the records of the employee Id on
the 1st tab.

How do I accomplish that?

Thanks in advance.

 

[Piet Linden]

I have a Form that the first tab includes the employee Id.  In this
form the 2nd tab that shows a query for "Paid Time off"and the
3rd .tab that has shows query of state licensures.

I want the sub report to pull only the records of the employee Id on
the 1st tab.

How do I accomplish that?

Thanks in advance.

Either use the LinkChild/LinkMaster properties of the subform or
modify the subform's SQL to include a valid WHERE clause, where you
point at the Primary Key control on the main form. The fact that
you're on a tab is a red herring. It has nothing to do with the
relationships at all.