Filter subform based upon field from another tab

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?
 
S

strive4peace

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
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronising subform from another subform 2
Usings tabs in forms with same primary key 6
Tab Control with multiple subforms 4
Access form tab control query 1
Referece a value in a Tab of a Form within a SubForm 2
Copy/Paste from one workbook to another not recognized by formulas 2
Linking bound subform to an unbound mainform 1
Subform - lookup/add new 3

Top