vba, The data I would like to filter by is not in the record source.
Let me illustrate the issue:
tblCourse:
fldCourseID (Primary Key)
fldCoach
tblAssignment: ("Sub-Table" to tblCourse)
fldAssignmentID (Primary Key)
fldCourseID (Foreign Key)
The form is for editing tblAssignment records. I would like for the user to filter by Coach, which as you can see is included in tblCourse.
Bob, my intent is to create a DLookup field in the continuous form based on the foreign key which is part of the record source. I would then like to filter the records within the same continuous form by the data that is returned. The first returned value for each foreign key is perfect.
Is there a way to apply an sql statement in the filter by form that would accomplish this purpose?
Thank you again for helping guys.