is it possible to get a 5 field based off entry in preeceding 4

[tjones]

I have a table that contains all the information for an activity. On the form enter the first four fields and have it filter table to narrow down the selection for Activity Name that meets the criteria entered in the first four fields.

form has field names:
cboSchoolID
cboSessionID
cboProgGradeID
cobCoreCompID
cboActivityName


refSchoolActivities (table containing all the data)
SchoolID
SessionID
ProgGradeID
CoreCompID
ActivityName

SELECT refSchoolActivity.SchoolID, tblActivityTaken.SessionID, refSchoolActivity.ProgGradeID, refSchoolActivity.CoreCompID, refSchoolActivity.ActivityName, refSchoolActivity.ActivityDesc
FROM ((((tblActivityTaken INNER JOIN refSchoolActivity ON (tblActivityTaken.SchoolID = refSchoolActivity.SchoolID) AND (tblActivityTaken.SessionID = refSchoolActivity.SessionID) AND (tblActivityTaken.ProgGradeID = refSchoolActivity.ProgGradeID) AND (tblActivityTaken.CoreCompID = refSchoolActivity.CoreCompID)) INNER JOIN refCoreComp ON tblActivityTaken.CoreCompID = refCoreComp.CoreCompID) INNER JOIN refSession ON tblActivityTaken.SessionID = refSession.SessionID) INNER JOIN refSchool ON tblActivityTaken.SchoolID = refSchool.SchoolID) INNER JOIN refProgGrade ON tblActivityTaken.ProgGradeID = refProgGrade.ProgGradeID
WHERE (((refSchoolActivity.SchoolID)=[Forms]![frmActivityTaken]![cboSchoolID]) AND ((tblActivityTaken.SessionID)=[Forms]![frmActivityTaken]![cboSessionID]) AND ((refSchoolActivity.ProgGradeID)=[Forms]![frmActivityTaken]![cboProgGradeID]) AND ((refSchoolActivity.CoreCompID)=[forms]![frmActivityTaken]![cboCoreCompID]));