Subquery in Form

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

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.
 
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.
Click to expand...

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.
 
Back
Top