Is it possible to set a query criteria based on the choice made in a combo box in a form.

[MichaelA]

I have a cascading combo box, the first is to select a name or nameID, the second combo box's row source is a query. When I run the query I filter it, choosing a person's name to get just their information. Can this filter or query criteria be set by choosing the name in the first combo box?

Thank you!

[orange]

More info on comboboxes than you expected at https://www.techonthenet.com/access/...oxes/index.php

[MichaelA]

More info on comboboxes than you expected at https://www.techonthenet.com/access/...oxes/index.php

Thank you but I don't see anything in there about queries.

[orange]

Can you post the "query sql" that is the rowsource of your second combo?

You could have a vba routine that gets executed on the afterUpdate event of combo1.
you would ensure the selection in first combo is valid, then use that value in the where clause of the query...
if I'm following your set up.

You want to run query X after selecting some relevant value from combo1?

[MichaelA]

I got it figured out. Thank you! Here's what I came up with.

SELECT DISTINCT qryMissingAssignments.StuID, qryMissingAssignments.FirstName, qryMissingAssignments.CourseID, qryMissingAssignments.AssignID, qryMissingAssignments.Assignments
FROM Students, Courses INNER JOIN qryMissingAssignments ON Courses.ID = qryMissingAssignments.CourseID
WHERE (((qryMissingAssignments.StuID)=[Forms]![Grades]![StudentID]) AND ((qryMissingAssignments.CourseID)=[Forms]![Grades]![CourseID]))
ORDER BY qryMissingAssignments.AssignID;

[orange]

Glad you have resolved the issue and posted your solution.