Hi Everyone
I have cross-posted this on Utter Access https://www.utteraccess.com/topics/2.../posts/2762703
I have 2 Listbox's - when I select an Item in the 1st Listbox I only want to see related records in the 2nd Listbox
1st List122 Row Source is as follows:-
Code:
SELECT qryObjectiveList.GoalObjectiveID, [ObjectiveLetterNumber] & " - " & [Objective] AS O, qryObjectiveList.ObjectiveID FROM qryObjectiveList WHERE (((qryObjectiveList.StudentID)=[Forms]![frmStudentsProgress]![pkStudentID])) ORDER BY qryObjectiveList.ObjectiveID;
2nd List187 Row Source is qryInterventionList
The SQL is :-
Code:
SELECT tblObjectiveInterventions.GoalObjectiveID, tblObjectiveInterventions.InterventionID, tbluInterventions.Intervention, tblObjectiveInterventions.ObjectiveInterventionID
FROM tbluInterventions RIGHT JOIN tblObjectiveInterventions ON tbluInterventions.InterventionID = tblObjectiveInterventions.InterventionID;
I am trying to filter the 2nd List by GoalObjectiveID with no success
Any help appreciated