If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter subform based upon field from another tab
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? |
#2
|
|||
|
|||
Filter subform based upon field from another tab
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 * Stukmeister wrote: 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? |
Thread Tools | |
Display Modes | |
|
|