Problems Filtering a subform

[tjones]

Glitch between main and subform filtering

This is all working nicely:

First I create the activities for the semester in the Activity Entry form
And create the Participant record (if not already in the system)
I then enroll each participant in activities for the semester.

When you create a record in the Activity enrollment for a participant their infomation updates to the Activity Attendance subform (created using wizard to pull information from 3 tables student, activity Info, activity enrollment)

The problem:

I need the Activity Attendence to filter to display only those participants in the Actitivity Entry - Activty
so in this instance ONLY "joe test" should be displaying in the Activity Attendance subform.

Record Source for Activity Attendance
SELECT [tblStudentInfo].[LastNameStd], [tblStudentInfo].[FirstNameStd], [tblActivityEnrollment].[SessionID], [tblActivityEnrollment].[WaitList], [tblActivityEnrollment].[Contacts], [tblActivityEnrollment].[TotalHours] FROM tblStudentInfo INNER JOIN tblActivityEnrollment ON [tblStudentInfo].[StudentID] =[tblActivityEnrollment].[StudentID];

when i try and link Master/Child by ActivityID and/or student (to the ActivityEnrollment form) the form just goes blank and pulls no records

and when i put this subform on the Activity Enrollment form it does not sync with the participant even when tying studentid and activityid

 

[sneuberg]

I can't see exactly what you are doing but the join in the record source for activity attendance might be a problem. Usually it's best to stick to one table per form. Could you upload you database?

 

[tjones]

Re: Problems Filtering a subform [FIXED]

to make an entry in subform1 (student info main form / activity enrollment subform) fill to subform2 (activity info main form / activity attendance subform)

Ensure "ActivityID" is in both main form tables and link via relationships

Enter "ActivityID" into the query that pull the information for subform1-activity enrollment

for some reason I was unable to just modify the query pulling for subform2 (activity attendance) but once i deleted the the subform and rebuilt it and added it to the activity main form everything worked.