Hello everyone, so basically I am making a student database that contains student grades, I have a query that gives me a list of what classes a specific student has taken that are part of their major. This is what the query returns:
So what I want to do is create a report that has a section like this where it lists all possible classes they can taken per that major:
I want to have a checkbox next to each class and have the box be checked off if they have taken the class, if they have not I want the box to be empty, so I don't necessarily need anything on the report like grades etc. I just want it checked off if they have taken that specific class . I want to know what I can put in the checkbox's control source where it would check the query results and check for a specific string like "Amat_108" and the set the checkbox to true if there is.