May I please have some assistance creating VB code in Access 2010, Windows 7. I have a main form labeled frm.Sponsors, the primary key (long Integer) is the field is [MSF_RERP]. I have another form that I wish to create a linkage from frm.Sponsors to frm.Coaches. frm.Coaches has a successful subform labeled frm.CoachAssignment. The primary key (long Integer) field that links frm.Coaches to frm.CoachAssignment is [MSF_Coach]. There are about 50 sponsor records in frm.Sponsors. Each sponsor has at least one record or Coach in frm.Coaches. Each Coach has at least one record (Coach assigned) to one sponsor in frm.CoachAssignment. Coaches (frm.Coaches) may be employed by multiple sponsors at one time. I have created relationships in my database: tbl.sponsor.MSF_RERP one-to-many tbl.CoachAssignment.MSF_RERP and tbl.CoachAssignment.MSF_Coach one-to-many tbl.Coaches.MSF_Coach. As you can see field [MSF_Coach] is not in frm.Sponsors this is my dilemma because I don’t know how to link main frm.Sponsors to subform frm.Coaches and then to subsubform frm.CoachAssignment. In case it may not be clear, the desired effect when the end-user opens the frm.Coach from frm.Sponsors it should only display coaches that are employed by the Sponsor [MSF_RERP].