Filter subform based upon field from another tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Parent form is related to Client table.
Tab1 has Client subform.
Tab2 has Project subform.
Tab3 has ProjectTask subform (ProjectTask is owned by Project)

On Tab2, I want to be able to select a Project and when Tab3 is selected I
want to be able to filter only the Project selected in Tab2.

How do I do that?
 
for the subform on tab3:

LinkMasterFields --> subform2_controlname.form!ProjectID
LinlkChildFields --> ProjectID

and then make sure ProjectID is in both places -- it can be hidden but
must be there

you may need to requery subform3 on the current event of subform2...

me.parent.subform2_controlname.form.requery

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top